Sync data from PostgreSQL to Access

by

Posted on by

Want to sync data from PostgreSQL to Access ?

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

Download Withdata DBCopier Download DBCopier

Synchronize data from PostgreSQL to Access

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

Choose source PostgreSQL database and logon.

sync PostgreSQL to Access - Choose PostgreSQL and logon

Choose target Access database and logon.

sync PostgreSQL to Access - Choose Access and logon

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

sync from PostgreSQL to Access - Task Window

then show the wizard.

1. Select source PostgreSQL tables to sync.

sync from PostgreSQL to Access - Open source database

2. List target Access tables.

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

sync data from PostgreSQL to Access - full synchronization

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

sync data from PostgreSQL to Access - upsert synchronization

3. Select Access tables to sync.

sync from PostgreSQL to Access - select tables

4. Sync PostgreSQL data to Access.

sync from PostgreSQL to Access - sync

More about PostgreSQL to Access converter

See also: