More Visual FoxPro challenges

[Noel]

I've been successful programmatically importing into Access a FoxPro free table using the TransferDatabase method on a specific dbf.

However, there's another dbf in the same Visual FoxPro application that I want to do the same with, but with no success.

I am, however, able to manually create an ODBC link to the dbf, but, I'm unable to do anything resembling importing data from the linked table. I.e. I wasn't able to do a make table query, nor was I able to do an append query, nor was I able to programmatically get records from the linked table into another Access table.

I believe the developers of the FoxPro application put some sort of read-only permission on the dbf, but why would that prevent me from copying the data to another table?

Any suggestion for getting the dbf data into a resident Access table would be much appreciated.

Thanks.

Noel

 

[Noel]

new development

it seems there were 2 fields in the linked table that would cause an odbc failure. After removing them from the make table query or the append query everything came out ok.

Although, I'd still love to hear if there is a way to use the transferdatabase method.

Thanks - Noel