Import data from SQL Server to Access

Import data from SQL Server to Access - Import single table

Click "Import From Table" at task dialog.

Import data from SQL Server Table To Access Table - task window

then show the Import Single Table form.

1. Select Source table.

Import data from SQL Server Table To Access Table - select source table

2. Select Target Table.

Import data from SQL Server Table To Access Table - select target table

3. Summary.

Import data from SQL Server Table To Access Table - summary

4. Import.

Import data from SQL Server Table To Access Table - import

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