Import data from Access to SQL Server

Click "Import From Query" at task dialog.

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

then show the Import Query form.

1. Enter Source Query.

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

2. Select Target Table

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

3. Summary.

Import data from Access Query To SQL Server Table - summary

4. Import.

Import data from Access Query To SQL Server 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.