April 6, 2009 at 2:47 am
Dear Sir,
I am facing a crictical problem while Importing data to Sql Server 2000.
The scenerio is as follows:
I had a .DBF file and i want all the data of the DBF to be imported to Sql Server 2000 using DTS wizard.
The DTS Wizard is throwing the below error.
"microsoft jet database engine external table is not in the expected format"
Error Calling OpenRowset on the provider.
Please provide me with some good solution as it is very urgent.
Thanks for your Kind Support,
Regards,
Mohammad Zubair Pasha.
April 6, 2009 at 3:15 am
If that's a Foxpro DBF, you might need to install a driver (free, I think) before this will work.
April 6, 2009 at 3:21 am
Can you Please tell me what is the driver download location
April 6, 2009 at 3:31 am
Here looks promising
but I'm no Foxpro guru.
April 6, 2009 at 3:45 am
Dear Sir,
I have installed Microsoft Foxpro Drivers and selected the DSN Driver as Microsoft Fox Pro driver (*.dbf) and it worked fine.
Thanks for your support.
Regards,
Mohammad Zubair Pasha.
April 6, 2009 at 3:59 am
That is good news - thank you for the feedback!
Viewing 6 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply