Wizard for Importing data from Oracle to Access

Click "Wizard - Import From Table" at task dialog.

Import Data From Oracle to Access - Task Window

then show the wizard.

1. Open Source table.

Oracle to Access wizard - Open Source

2. Select a destination table and config fields.

Oracle to Access wizard - select table

3. Preview data.

Oracle to Access wizard - preview

4. Import.

Oracle to Access wizard - import

For repeatable task, you can click "Save Session" button to save config, then run it next time. see also: Save and load session.