Convert Microsoft Access MDB or ACCDB Tables to MySQL
Question details
The user wants to migrate a Microsoft Access MDB or ACCDB database to MySQL.

- Product
- Microsoft Access and MySQL
- Device & OS
- not provided
- Scenario
- Move database tables and data to MySQL while planning how to handle other Access objects.
- Observed behavior
- Tables and data can be migrated, but queries may need rewriting, and forms, reports, and VBA code generally require separate redesign or continued use in Access.
Open the database in Access and identify the tables, relationships, queries, and other objects you need. Make sure you can connect to a MySQL server and have permission to create tables in the destination database.
Export Access tables as CSV and import them into MySQL
Use this approach to move table data when you can export each Access table separately.
CSV transfers table data, not relationships, indexes, forms, reports, or VBA code. Complex fields, attachments, and data types such as dates may need special handling.
In Access, select a table in the Navigation Pane, then choose External Data > Text File. Follow the export wizard to save a delimited CSV file and include field names in the first row.
Open MySQL Workbench, select your MySQL connection, and locate the destination database in the Schemas panel.
Right-click the destination schema and select Table Data Import Wizard. Choose the CSV file, create a new table or select an existing one, and review the column mappings and data types before importing.
Export and import each remaining table. In MySQL Workbench, use the table editor to review column types and create the required primary keys, indexes, and foreign keys.
In MySQL Workbench, run SELECT queries to compare row counts and sample values with Access. Review Access queries for MySQL syntax changes, and plan separately for forms, reports, and VBA.

Plan a broader migration with the MySQL guide
Use a migration guide or specialist help for larger databases and complex Access objects.
Work with exported Access data in WPS Spreadsheets
WPS Office is a free, lightweight alternative with a familiar interface for working with spreadsheet exports. Open CSV data in WPS Spreadsheets to review it or move spreadsheet-based work from Microsoft Office; WPS does not convert Access databases to MySQL.

Frequently Asked Questions
Can I convert Access forms and reports directly to MySQL?
No. MySQL stores database data and related database objects, but Access forms and reports generally need to remain in Access or be redesigned in another application.
Will my Access queries work unchanged in MySQL?
Not necessarily. Review each query's SQL, functions, and data types, then test and rewrite it in MySQL Workbench where needed.
How do I import an Access table into MySQL Workbench?
Export the table from Access using External Data > Text File. In MySQL Workbench, right-click the destination schema, select Table Data Import Wizard, and choose the exported CSV file.
Does a CSV export preserve Access relationships?
No. After importing the tables, use the MySQL Workbench table editor to create the required keys and relationships, then check that the related data is consistent.




