Link VFP table using VFP OLEDB driver

[mcollins]

Hi,

I have an application that uses VFP 9 data. I tried to create a link from Access using ODBC, but I get an error. I read that the VFP ODBC driver doesn't support the latest VFP features (I suspect that this database may use new datatypes) and that it is recommended to use the VFP OLEDB driver, rather than the ODBC driver.

Is it possible to create a link to VFP tables using the VFP OLEDB driver, just using the Access interface (without using VBA)? I don't see an OLEDB option under the 'Files of type:' picklist.

Thanks,
Mike

 

[PHV]

Have a look here:

http://www.connectionstrings.com/

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[mcollins]

Thanks PH. Sounds promising. But I still am not quite sure how to do it. But just having you say that that is a way to get it done, gives me a reason to pursue further in that direction.