This is a really neat trick I’ve learned that can get any records from other databases mapped to a MySQL database. I had quite a few MS Access databases and decided to reprogram the applications to a web application. This left me with getting the records from MS Access to the new MySQL database.
1. Setting up an ODBC connection to your data source.
Go to the computer settings screen, system tools, ODBC connections. Create a SYSTEM DSN to your source database.
2. Create a MySQL database and desired tables.
3. Customize script and call it.
The script can be downloaded here. The important parts of the script are:
If you want to expand your field list (MySQL tables have a higher field count), make sure you include ‘dummy values’ in the SQL INSERT statement to match the number of fields extracted.