Sync data from Oracle to Access

by

Want to sync data from Oracle to Access ?

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

Download Withdata DBCopier Download DBCopier

Synchronize data from Oracle to Access

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

Choose source Oracle database and logon.

sync Oracle to Access - Choose Oracle and logon

Choose target Access database and logon.

sync Oracle to Access - Choose Access and logon

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

sync from Oracle to Access - Task Window

then show the wizard.

1. Select source Oracle tables to sync.

sync from Oracle to Access - Open source database

2. List target Access tables.

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

sync data from Oracle to Access - full synchronization

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

sync data from Oracle to Access - upsert synchronization

3. Select Access tables to sync.

sync from Oracle to Access - select tables

4. Sync Oracle data to Access.

sync from Oracle to Access - sync


More about Oracle to Access converter

See also: