Want to bulk import data from Access to MySQL ?
Using DBCopier, a native GUI software, a Access to MySQL converter, you can bulk import data from Access to MySQL (MariaDB, Percona) easily and fast.
- Step by step, just a few mouse clicks.
- Support schedule and automate db importing.
- Support Windows, Linux, macOS.
- Can work without Microsoft Access installed.
Here’s how to.
Bulk import data from Access to MySQL (MariaDB, Percona)
Choose source Access database and logon.
Choose target MySQL database and logon.
Click “Wizard – Import All Tables” at task dialog.
then show the wizard.
1. Open source Access .
2. List target MySQL tables.
3. Select MySQL tables to import.
4. Bulk import data from Access to MySQL.
Save/load session of importing Access to MySQL (MariaDB, Percona)
You can save/load session to run “Access to MySQL” importing repeatly.
1.Save Session.
Click “Save Session” button, then enter a session file name.
click “OK” button.
2.Load Session.
Click the “Open Saved Session” in task window, select a session file.
then show the wizard form, click a few “Next” to bulk import Access to MySQL.
Run in command line for importing Access to MySQL
You can run “Access to MySQL” importing in command line.
When you save session, you can click “Save & Make Batch File”.
The “Save & Make Batch File” form shows.
Click “OK” button, you’ll create a batch file, in Windows, like this:
C: cd "C:\Users\pansh\AppData\Local\Programs\DBCopier" DBCopier task="C:\Users\pansh\Documents\test.ula" logfile="C:\Users\pansh\Documents\test.log"
You can run this batch file in command line.
Run as scheduled task for importing Access to MySQL
You can run “Access to MySQL” importing automatically at specific time.
On Linux/macOS, you can use Crontab.
For macOS, How to Fix Cron Permission Issues in macOS.
On Windows, in “Save & Make Batch File” form, you can click “Create & Schedule Task” to set a scheduled task.
And then, with scheduled task wizard, step by step.
You’ll see created task listed in scheduled task list.
Download
Here you can download DBCopier, and buy DBCopier.
Access → MySQL reference
Type mapping
| Value kind | in Access | in MySQL |
|---|---|---|
| Int | Long Integer | INT |
| Bigint | Long Integer | BIGINT |
| Decimal | Decimal | DECIMAL(p,s) |
| Float | Double | DOUBLE |
| Text | Text(n) | VARCHAR(n) |
| Long text | Long Text | LONGTEXT |
| Date | Date/Time | DATE |
| Datetime | Date/Time | DATETIME |
| Binary | OLE Object | LONGBLOB |
| Boolean | Yes/No | TINYINT(1) |
| JSON | Long Text | JSON |
Dialect differences
Both Access and MySQL are database servers, so the differences below are dialect-level: the same concept is spelled differently on each side.
| Property | in Access | in MySQL |
|---|---|---|
| port | (file-based) | 3306 |
| identifiers | [square brackets] | `backtick` |
| row limit | SELECT TOP n | LIMIT n |
| dates | Date/Time | DATETIME, TIMESTAMP, DATE, TIME |
| long text | MEMO | TINYTEXT / TEXT / MEDIUMTEXT / LONGTEXT |
| binary | OLE Object | BLOB / TINYBLOB / LONGBLOB |
Command line
| Side | Command |
|---|---|
| MySQL | mysqldump, or mysql -e "SELECT ..." > out.csv |
| MySQL (load) | mysqlimport, or LOAD DATA INFILE |
Convert your data online, free
Free in-browser converters for CSV, Excel, JSON, XML and SQL: Withdata Online Data Conversion. Large files, batch conversion or scheduling? See the offline desktop apps, or browse all data conversion tools.