Migrate MS Access Backend to MySQL

[SierraJuliet]

Anyone have good method for transferring MS Access backend tables to MySQL?

I tried ODBC Data Source but gives me an error each time.

[ranman256]

thats how data connectivity works, via ODBC driver. Do you have a valid driver?

[SierraJuliet]

I continually get an error when trying to use ODBC Data Source. I do not understand how it functions and may be cause for confusion.







This is ODBC Data Source:

[SierraJuliet]

UPDATE: I finally added "MySQL ODBC 5.3 Unicode Driver" but still working on how to add the database name when it is locally available (no need to remote the connection - obviously). Now get an ODBC call failed message.

[SierraJuliet]

Whoops! I got it to work. I needed the MySQL database there and waiting for the connection first, duh!