Sync data from Access to MySQL

by

Posted on by

Want to sync data from Access to MySQL ?

Try Withdata DBCopier, a Access to MySQL converter for Windows, Mac, and Linux, Synchronize Access to MySQL, Easy and Fast.

Download Withdata DBCopier Download DBCopier

Synchronize data from Access to MySQL

Login to Access and target MySQL -> Select source Access tables -> Set target MySQL tables -> Sync Access data to MySQL

Choose source Access database and logon.

sync Access to MySQL - Choose Access and logon

Choose target MySQL database and logon.

sync Access to MySQL - Choose MySQL and logon

Click “Wizard – Import All Tables” at task dialog.

sync from Access to MySQL - Task Window

then show the wizard.

1. Select source Access tables to sync.

sync from Access to MySQL - Open source database

2. List target MySQL tables.

Set “Import Type” to “Replace”, it will do a full synchronization.

sync data from Access to MySQL - full synchronization

Or set “Import Type” to “Upsert”, it will do a upsert synchronization.

sync data from Access to MySQL - upsert synchronization

3. Select MySQL tables to sync.

sync from Access to MySQL - select tables

4. Sync Access data to MySQL.

sync from Access to MySQL - sync

More about Access to MySQL converter

See also: