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.
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.
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.
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.
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!
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply