Copy Access data from table to table

Click "Wizard - Table To Table" at task dialog.

Copy Access data from table to table - Task Window

then show the wizard.

1. Open Source table.

Copy Access data from table to table - Open Source

2. Select a destination table and config fields.

Copy Access data from table to table - select table

3. Preview data.

Copy Access data from table to table - preview

4. Copy.

Copy Access data from table to table - copy

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