Migrates data from MS Access (*.mdb,*.accdb) To MySQL database

This article explains how to using ESF Database Migration Toolkit to migrate data from MS Access to MySQL database in 3 easy steps.

Requirements:
Windows XP or higher.
ESF Database Migration Toolkit download.
MS Access 97 or higher.
MySQL 3.23 or higher.

Introduction:

1). In "Choose a Data Source" dialog, Choose "Microsoft Access (*.mdb)" or "Microsoft Access 2007-2012 (*.accdb)"

  • Press "..." button to find the Access MDB (or ACCDB) file.
  • If there is workgroup information, press "Lock" button to set it.
  • MS Access

2).In "Choose a Data Destination" dialog, choose "MySQL Database"

  • Put the server name, port (default is 3306), username, password.
  • MySQL supporting some different Storage Engines, please click here to get more information about MySQL Storage Engine.
  • In "CharacterSet" field choose a character-set like UTF-8.
  • Press "Refresh" button to list all MySQL Databases automation, you can select a database directly, or input an new database name, this toolkit can create the new database in converting.
  • MySQL

3). In "Select source Tables(s) & View(s)" dialog

  • Select the tables which will be migrated.
    Select Tables&Views

  • Click "..." to setting the table options or re-map the table structure.
    Transform

4). In "Execution" Dialog

  • Click "Submit" to starting migration, this tookit will help you migrate data from MS Access to MySQL without intervention.
    Execute

5). Finished

If you have any questions or suggestions, please contact us. Thank you for your time!