Our ERP system is built around Fox Pro tables. I'm been successfull in connecting to the .dbf files through ODBC, and then using a make table query to create a local copy in Access to do what I need to do.


I'm working on moving my copied tables from Access to MySQL now.

I've spent hours searching the internet, but can't find anything on how to do this. Is there a way to directly connect MySql to the VFP .dbf files, and then mimic the functionality of an access make table query?

I doubt that there is a way to connect to .dbf files using nothing but MySql.

If you have already moved the tables into an .mdb file then you can just export them to
your MySql database via ODBC.