Access to MySQL Converter — Free Online Tool
Convert Microsoft Access databases (.mdb, .accdb) to MySQL SQL files. Upload your Access database and download a SQL file with CREATE TABLE and INSERT statements.
Convert in Three Steps
The whole process takes under a minute, even for large files.
Upload your file
Drag and drop or click to browse. SQL, SQLite, CSV and JSON files up to 50 MB are accepted.
Pick your target
Select the output format. The source format is detected automatically from your file.
Download the result
Your converted file is ready in seconds. Import it directly into your database.
Every Syntax Difference Handled Automatically
Microsoft Access is a popular database for small businesses and desktop applications, but when you need to scale to a web application or share data with a MySQL server, migration is necessary. Our converter handles the schema and data conversion automatically.
mysql -u root -p mydb < output.sql. Review the generated schema and adjust column types as needed. Related Conversions
Other conversions you might need alongside Access to MySQL.
Common Questions
.mdb (Access 97-2003) and .accdb (Access 2007+) files are both supported.
Foreign key relationships are converted to MySQL foreign key constraints where possible.
OLE Object fields become BLOB, Memo fields become TEXT, and AutoNumber becomes INT AUTO_INCREMENT.
Related Conversions
Ready to Convert Your Access to MySQL File?
Upload your file above and get a converted result in under a minute. No account, no cost, no catch.