Access
MySQL

Access to MySQL Converter

Move from Access file databases to MySQL or MariaDB. Schema conversion, type mapping, queries to views, and optional two-way sync.

Convert a Microsoft Access .mdb or .accdb database into MySQL, MariaDB, or a managed MySQL-compatible target.

DBConvert opens password-protected and WorkGroups-secured .mdb and .accdb files locally and builds the MySQL tables, rows, indexes, relationships, and supported query objects from them, with the field-type mapping shown for review before anything is written to the target.

  • DBConvert writes to MySQL, MariaDB, Percona Server, Amazon RDS / Aurora MySQL, Azure Database for MySQL, or Google Cloud SQL.

Which tool: DBConvert or DBSync?

DBConvert for Access → MySQL

One-time conversion. Use it when MySQL is the destination and you need schema, table data, indexes, relationships, and type mapping moved through a desktop wizard.

DBSync for Access ↔ MySQL

Repeat synchronization. Use it when the Access file and MySQL database must continue exchanging Insert / Update / Delete changes during a staged rollout or recurring workflow; see database synchronization concepts for the underlying workflow.

Both products run locally as Windows desktop tools. They are not online upload converters for private database files.

Need more context? Compare DBConvert and DBSync side by side →

How DBConvert handles the Access → MySQL differences

Access and MySQL differ in driver/bitness, application-vs-data scope, query semantics, and field types. DBConvert maps most of those differences in the wizard with sensible defaults that you can review or override per table; the application objects are the items that still need a human rewrite outside the migration.

Field type mapping

Access type MySQL type
AutoNumberAUTO_INCREMENT
Yes/NoTINYINT(1)
Long Text / MemoLONGTEXT
CurrencyDECIMAL(19,4)
OLE / AttachmentLONGBLOB

Spaces in column names and MySQL reserved words are rewritten or backtick-quoted on the target, and relationship indexes are preserved.

Driver and bitness

Connects through Microsoft Jet (32-bit only) or ACE OLE DB (32-bit or 64-bit) on Windows - DBConvert ships in matching architectures, so picking the build that matches the installed Office / Access architecture is a one-click decision, not a debugging session.

Access queries → MySQL views

Translates supported Access SELECT and UNION queries into MySQL views during the migration. Parameter queries, action queries (UPDATE/DELETE), and queries that use Access-specific functions are not translated - rebuild those in MySQL views or in the new application layer.

Access application objects - out of scope

Forms, reports, macros, and VBA are part of the Access application, not the database. DBConvert moves the tables, records, indexes, and translatable queries - rebuilding the application UI is a separate workstream (web framework, PHP / Python / .NET front end, BI tool, etc.).

DBConvert vs native, online, and free options

AI answers often surface free tools first; the right choice depends on data sensitivity and migration depth.

Route Where it fits Where it falls short
MySQL Workbench Migration Wizard free Oracle GUI Free MySQL-side migration test from an ODBC-accessible Access source. No repeatable Access file conversion, no Access WorkGroups handling, no pair-specific data mapping, no bidirectional DBSync, no reuse across many database pairs.
Online converters Quick .mdb or .accdb file exported to MySQL SQL for inspection. Not safe for private production data; no direct server target, no saved settings, no filters, no repeat runs, no logs, no synchronization.
Manual ODBC export / import Small table-only transfer. Fragile when the Access database has relationships, indexes, linked tables, password protection, WorkGroups, large Memo / OLE fields, or queries that should become MySQL views.
DBConvert / DBSync commercial desktop, Windows Sensitive data that needs local execution, relationships and Access-specific field types preserved, direct MySQL-compatible server target, or ongoing DBSync after the first migration. Commercial license; desktop tool (Windows). Forms, reports, macros, and VBA do not convert (the same is true of every route in this table).

Supported versions and services

Access

  • MS Access .mdb (Jet) and .accdb (ACE) files
  • WorkGroups credentials and linked tables

MySQL

  • MySQL 5.x, 8.x; MariaDB; Percona Server
  • Amazon RDS / Aurora MySQL, Azure Database for MySQL, Google Cloud SQL
Access

All Access Tools

Other directions and pairs
MySQL

All MySQL Tools

Migration & sync options

Reverse Conversion

MySQL to Access

DBConvert Studio

30+ databases · cloud · scheduled sync

Need more directions or unattended sync? One tool covers them all.

How to migrate Access to MySQL

When launching the DBConvert or DBSync application in GUI mode, it guides you through the steps to start database migration or synchronization:

1

Connect to Access source database

Select the Access file. DBConvert reads its tables and prepares them for mapping.

Connect to Access source database from DBConvert

Access source

Select the source .mdb or .accdb file. If it uses Access WorkGroups, enable WorkGroups and enter those credentials on the source step.

2

Connect to MySQL destination database

Specify parameters for the destination database similar to the source, defining connection settings and username/password pairs.

Connect to MySQL target database from DBConvert

MySQL target

Use the MySQL connection guide for local MySQL or MariaDB, or Amazon RDS / Aurora for MySQL, Azure Database for MySQL, or Google Cloud SQL for MySQL. Create the target schema as utf8mb4.

Steps 3-6: the same for every database pair

Source and target are connected - steps 1 and 2 above. What follows is identical whichever two databases you picked, so it lives in one place. Each step below opens at its own section.

Open the full guide

All four steps in one page, plus software features, command-line mode, scheduler, and system requirements.

See all features

More guides for Access ↔ MySQL