Migrating Access Databases to MySQL

The easiest way to migrate your Access database to MySQL is to export a MySQL-compatible SQL file using MDB Viewer and then upload this file using the wonderful Open Source app Sequel Pro.

For a general introduction to SQL files, see Exporting as SQL.

Step by Step

In MDB Viewer:

MySQL Export Options

In Sequel Pro:

Access Types vs. MySQL Types

Access TypeMySQL Type
Boolean BOOLEAN
Byte INTEGER
Integer INTEGER
Long Integer INTEGER
GUID TEXT
Decimal DOUBLE
Money DOUBLE
Float DOUBLE
Double DOUBLE
Date/Time DATETIME
Text VARCHAR
Memo LONGTEXT
Ole LONGBLOB

When exporting for MySQL, backticks are used to quote table and column names. Therefore table names containing spaces etc. work just fine.