How to link FoxPro to Access ?

[alain17]

Hello,




I want to link or import FoxPro tables (.dbf) into an Access 2016 database.


I can't do it and I need your help.


For this, I must visibly configure an ODBC driver.


Questions :


1 - where to find this ODBC driver?


2 - how to use it in Access 2016?


Thank you in advance !

[ArviLaanemets]

I'm not sure about Access, but I know 64-bit SQL server doesn't have ODBC driver for dbf-files. As MS owns Foxpro, Access and SQL Server, it is highly possible, that you can import dbf files only into 32-bit Access.

I myself installed 32-bit SQL Server Express (freeware), and imported dbf-files there, and then imported them into 64-bit SQL Server.

[pbaldy]

I've got Access connected to FoxPro tables with the "Microsoft Visual FoxPro Driver". That said, I couldn't find it to install on a new server not long ago, I just still have it installed on workstations. If memory serves I installed the program that used the FoxPro tables and it installed the driver.

[isladogs]

You should be able to link/import as shown below

The screenshot is from 64-bit A365