Using MsSqlToAccess, you can batch transfer data from SQL Server tables to Access easily and fast, just a few mouse clicks!
Batch transfer data from SQL Server tables To Access tables
Click “Wizard – Import All Tables” at task dialog.
then show the wizard.
1. Open Source.
2. Select Destination.
3. Select tables to import.