Wizard for Importing data from MySQL to Access

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

Import Data From MySQL to Access - Task Window

then show the wizard.

1. Open Source table.

MySQL to Access wizard - Open Source

2. Select a destination table and config fields.

MySQL to Access wizard - select table

3. Preview data.

MySQL to Access wizard - preview

4. Import.

MySQL 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.