First, you need and install MsSqlToAccess.
MsSqlToAccess is a data conversion tool that helps DBA and database programmer unload data from Sql Server schema into Access.
Unload Data From Sql Server Schema Into Access – 4 Steps
Click “Wizard – Import All Tables” at task dialog.
then show the wizard.
1. Select schema and tables.
2. Access tables.
2. select and map tables.
3. Export.
More about MsSqlToAccess – the tool to unload SQL Server Schema data to Access.