FoxPro to DTS error - file not in expected format
Posted on 2004-09-23
I am attempting to use DTS to import some FoxPro tables into SQL 2000. When I use the Visual FoxPro driver and a DSN I do not get all the .dbf tables.
When I try a different way of getting the tables over (i.e. DBase III driver) I see all of the tables, but upon selection of one I get the error "External Table is not in the expected format" and "Context: Error calling openrowset on the provider".
I can open all of the tables in DBF Viewer 2000 no problem.
This has to be an automated process, so I cannot manually go and convert the file(s) every night. I just need to see the missing tables and bring the data over.
To help out I have the following tables accompanying the DBF file:
I just need to run DTS and get the data. All of the other tables are imported and it works fine. Any ideas?