Migrate from Access 2010 to MySQL5.6 via ODBC?

[Ian Hingley]

Hi

Total MySQL newbie here.

15 years experience with SQL Server though.

Trying to migrate an Access 2010 database to MySQL5.6
I've spent ages trawling the web on this one.
Some say just use ODBC
Some say you need a 3rd-Party tool
Some say it used to work but doesn't any more.

I'm trying the ODBC route. There's a migration wizard which claims to connect to Generic RDBMS, so I assume this should work.

Here's how far I get:

Create an ODBC datasource to the Access database.
Start the MySQL Migration Wizard.

Source database system = Generic RDBMS
Connection Method = ODBC Datasource
Pick my datasource name, Test Connection OK, click Next.

Target Stored Connection = Local instance MySQL5.6
Test Connection OK, click Next.

Fetch Schemata List, click Next.

Schemata Selection
Dialog shows Catalog/Schema showing the path and the mdb file name.
Below that there is a circular database symbol with mdb.none
I click to Include these and click Next.

Within seconds of opening the Reverse Engineer Source screen, I get a fatal 'MySQL has encountered an error' message and MySQL crashes out completely.

Can someone point out what I'm doing wrong please? I seem to have wasted a lot of time on this.

Thanks

Ian