Sync data from Access to PostgreSQL

by

Posted on by

Want to sync data from Access to PostgreSQL ?

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

Download Withdata DBCopier Download DBCopier

Synchronize data from Access to PostgreSQL

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

Choose source Access database and logon.

sync Access to PostgreSQL - Choose Access and logon

Choose target PostgreSQL database and logon.

sync Access to PostgreSQL - Choose PostgreSQL and logon

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

sync from Access to PostgreSQL - Task Window

then show the wizard.

1. Select source Access tables to sync.

sync from Access to PostgreSQL - Open source database

2. List target PostgreSQL tables.

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

sync data from Access to PostgreSQL - full synchronization

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

sync data from Access to PostgreSQL - upsert synchronization

3. Select PostgreSQL tables to sync.

sync from Access to PostgreSQL - select tables

4. Sync Access data to PostgreSQL.

sync from Access to PostgreSQL - sync

More about Access to PostgreSQL converter

See also: