Sync data from DB2 to Access

by

Want to sync data from DB2 to Access ?

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

Download Withdata DBCopier Download DBCopier

Synchronize data from DB2 to Access

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

Choose source DB2 database and logon.

sync DB2 to Access - Choose DB2 and logon

Choose target Access database and logon.

sync DB2 to Access - Choose Access and logon

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

sync from DB2 to Access - Task Window

then show the wizard.

1. Select source DB2 tables to sync.

sync from DB2 to Access - Open source database

2. List target Access tables.

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

sync data from DB2 to Access - full synchronization

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

sync data from DB2 to Access - upsert synchronization

3. Select Access tables to sync.

sync from DB2 to Access - select tables

4. Sync DB2 data to Access.

sync from DB2 to Access - sync


More about DB2 to Access converter

See also: