Access 2013 Linked Tables to DBF files
15:42 11 Aug 2014

I have searched here and Google, with no solution so far.

The problem is Access 2013 no longer wants to connect to DBF.

Each month, I will get 33 DBF files (each with a CDX file) that I have to import into MySQL. The front end for this is Access 2013.
I've built a few other applications that do similar functions, so I'll just tweak one of them for this new data.

I don't know the the actual source of the original data, but it's my understanding that dbase & visual foxpro use the same format.

The application is designed to link to the data files, where I'll run queries (and maybe VBA as well) to port the data into tables linked to MySQL. All tables are linked using VBA and a DSN-Less connection.

I can use VFPOleDb, or something else if it gets me what I want. I've actually already installed this, but can't figure out the code to do what I need.

I'm running 64-bit Access & Windows 7.

Thanks.

odbc oledb ms-access-2013 dbf visual-foxpro