Convert MS Access to MySQL in Three Simple Steps
Step 1: Select the MS Access database and tables to convert
Step 2: Select the target MySQL database
Step 3: Start the conversion
Data Loader makes converting MS Access databases to MySQL a simple, point-and-click job. It supports MS Access MDB, 2007/2010/2013 ACCDB databases, and even Access runtime (MDE, ACCDE) files, alongside almost all versions of MySQL. You can filter columns and specify WHERE conditions to load only certain rows.
Converts databases and creates schemas and table structures automatically — without writing a single line of code.
Also loads data into existing tables, with full column mapping between source and target when needed.
Migrates integrity constraints and indexes alongside your data.
UPSERT updates matching rows or inserts new ones; INSERT loads only rows that don't already exist in the target. APPEND, DROP, and REPLACE options are also available.
Run conversion jobs automatically at intervals you specify.
Uses bulk loading for blazing speed into MySQL, and can generate MySQL SQL dump files when you don't have direct server access.
Download the free trial edition and test it yourself. It's fully functional except for a 50-rows-per-table-per-run limit.
Download MS Access to MySQL Converter
Wizard-based and fast, completely user friendly. Select single or multiple tables to transfer, select or deselect columns for migration, change target table datatypes and widths, with automatic checking of datatype mismatches and the ability to specify WHERE conditions to filter data.
Rated best in its category by many websites, and one of the most popular products in the Database Apps section on download.com — trusted by thousands of customers across the world. Standard Version costs just $99.
Download Free Trial Version Now