Import data from SQL Server to Access

Click "Import From Query" at task dialog.

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

then show the Import Query form.

1. Enter Source Query.

Import data from SQL Server Query To Access Table - enter query

2. Select Target Table

Import data from SQL Server Query To Access Table - enter file name

3. Summary.

Import data from SQL Server Query To Access Table - summary

4. Import.

Import data from SQL Server Query To Access Table - export

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