First, you need and install MsSqlToAccess.
MsSqlToAccess is a data conversion tool that helps DBA and database programmer export SQL Server data to Access.
Export SQL Server All Tables To Access – 4 Steps
Click “Wizard – Import All Tables” at task dialog.
then show the wizard.
1. Select source tables.
2. Access tables.
3. Select and map tables.
4. Import.
More about MsSqlToAccess – the tool to batch export SQL Server data to Access.