Sync data from MySQL to Access

by

Want to sync data from MySQL to Access ?

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

Download Withdata DBCopier Download DBCopier

Synchronize data from MySQL to Access

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

Choose source MySQL database and logon.

sync MySQL to Access - Choose MySQL and logon

Choose target Access database and logon.

sync MySQL to Access - Choose Access and logon

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

sync from MySQL to Access - Task Window

then show the wizard.

1. Select source MySQL tables to sync.

sync from MySQL to Access - Open source database

2. List target Access tables.

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

sync data from MySQL to Access - full synchronization

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

sync data from MySQL to Access - upsert synchronization

3. Select Access tables to sync.

sync from MySQL to Access - select tables

4. Sync MySQL data to Access.

sync from MySQL to Access - sync


More about MySQL to Access converter

See also: