Sync data from Access to SQLite

by

Posted on by

Want to sync data from Access to SQLite ?

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

Download Withdata DBCopier Download DBCopier

Synchronize data from Access to SQLite

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

Choose source Access database and logon.

sync Access to SQLite - Choose Access and logon

Choose target SQLite database and logon.

sync Access to SQLite - Choose SQLite and logon

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

sync from Access to SQLite - Task Window

then show the wizard.

1. Select source Access tables to sync.

sync from Access to SQLite - Open source database

2. List target SQLite tables.

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

sync data from Access to SQLite - full synchronization

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

sync data from Access to SQLite - upsert synchronization

3. Select SQLite tables to sync.

sync from Access to SQLite - select tables

4. Sync Access data to SQLite.

sync from Access to SQLite - sync

More about Access to SQLite converter

See also: