MsSqlToAccess - Convert data from SQL Server to Access »

Download MsSqlToAccess Free Trial »     Buy MsSqlToAccess Now »

Wizard for Importing data from SQL Server to Access

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

Import Data From SQL Server to Access - Task Window

then show the wizard.

1. Open Source table.

SQL Server to Access wizard - Open Source

2. Select a destination table and config fields.

SQL Server to Access wizard - select table

3. Preview data.

SQL Server to Access wizard - preview

4. Import.

SQL Server 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.