Using MsSqlToAccess, you can transfer data from SQL Server query result to Access table easily and fast, just a few mouse clicks!
Transfer data from SQL Server query To Access 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.