Using AccessToMsSql, you can transfer data from Access query result to SQL Server table easily and fast, just a few mouse clicks!
Transfer data from Access query To SQL Server table
Click “Wizard – Import From Query” at task dialog.
then show the wizard.
1. Set a query.
2. Select a destination table and config fields.
3. Preview data.