How do I use OLEDB to link to a Visual FoxPro file

[vvenk]

Hello:

I am trying to link a Visual FoxPro file into an Access 2008 database. Under
External Data / More, I see a ODBC option but not a OLEDB option.

Can somebody tell me how I can link this table using OLEDB?

Thanks.

Venki

 

[Douglas J. Steele]

AFAIK, it's not possible to use OleDB to link tables in any version of
Access.

The only place where you can use OleDB is in code when defining an ADO
connection.