Edit: added sample table output in MySQL
MySQL Workbench 6.2 introduces support for MS Access migration.
This tutorial should help you get your Access tables,
indexes, relationships and data in MySQL.
Because MS Access ODBC drivers are only available for Windows,
migrating from it is also only possible from Windows. As for
the destination MySQL server, you can have it in the same local
machine or elsewhere in your network.
MS Access stores relationship/foreign key information in an
internal table called MSysRelationships. That table
is protected against read access even to the Admin user, so if
you try to migrate without opening up access to it, you will get
an error like this:
 [Microsoft][ODBC Microsoft Access Driver] Record(s) cannot be read; no read permission on 'msysobjects'. (-1907) (SQLExecDirectW)
The steps to grant read access to …[Read more]