Others

Convert Microsoft Access MDB or ACCDB Tables to MySQL

Muhammad TalhaMuhammad Talha Nov 14, 2026 869 views

Question details

The user wants to migrate a Microsoft Access MDB or ACCDB database to MySQL.

Convert Microsoft Access MDB or ACCDB Tables 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.
Before you start

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.

Solution 1Recommended

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.

1
Export a table from Access

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.

2
Connect to MySQL

Open MySQL Workbench, select your MySQL connection, and locate the destination database in the Schemas panel.

3
Import the CSV file

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.

4
Repeat and rebuild the schema

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.

5
Validate data and other objects

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.

Export Access tables as CSV and import them into MySQL
Access objects do not all migrate: Forms, reports, and VBA code generally cannot be converted into MySQL database objects. Keep using them in Access where appropriate or redesign them in another application.
Free Microsoft Office alternative

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.

Review CSV exports from Access tables in a spreadsheetOpen and edit Microsoft Excel XLSX and XLS filesUse a familiar interface for a smoother move from Microsoft OfficeWork with a free, lightweight office suite
microsoft office alternative - wps office

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.