Error when reading .dbf file in VB6

[jjames]

I'm trying to import data from several dBase tables.

I am able to read all the files successfully except one. I get the following error when trying to read this table....

[Microsoft][ODBC dbase Driver] External table is not in the expected format.

This table has an associated .fpt file which I believe is for memo fields. None of the other tables has an .fpt file so I'm thinking this may be the problem?


I'm connecting to the database using ADO. Below is the DNSless connection string. I've been trying other drivers but get the same results...

objData.Connect "Driver={Microsoft dBASE Driver (*.dbf)};" & _
"DriverID=533;" & _
"Dbq=C:\PROGRAM FILES\APPLICATION\DATA"

Any help with this will be appreciated. Thanks.

 

[TomKane]

The dao/jet engine has "native" foxpro compatibility - do you get the same problem with that?

 

[jjames]

I haven't tried DAO in VB6. I have tried opening the same dbf file in Crystal Reports using DAO. I tried all versions available, dBase 5.0, dBase IV and dBase III, all with the same error. Do you have a sample connection string for DAO in VB6.0?

 

[TomKane]

Take a look at this

http://support.microsoft.com/default.aspx?scid=kb;en-us;148361