Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Jet Engine problem

Author  Topic 

hasanali00
Posting Yak Master

207 Posts

Posted - 2005-10-12 : 09:32:28
I am trying to import from a DBF file.

But using the DTS Import/Export Wizard I get the following error when I choose my DBF file (it works OK for other files). This file is about 6MB.

Please download the error imgage from here
http://s55.yousendit.com/d.aspx?id=0P50SMNOYY9X30M53UH8XBVEK2

any idea what I need??

thanks

jsmith8858
Dr. Cross Join

7423 Posts

Posted - 2005-10-12 : 09:43:21
Maybe use Access to convert it into a table in an MDB file first, and then import that? Sounds like DTS isn't working so well with DBF files.
Go to Top of Page

hasanali00
Posting Yak Master

207 Posts

Posted - 2005-10-12 : 10:48:32
Well I tried to open the DBF file in Access... first Access asked me to select an Index file, which I cancelled..Then Again I got 'Unexpected error from external database driver (15877).

Could it be something wrong with the file??

regards
Go to Top of Page
   

- Advertisement -