First, you need and install MsSqlToAccess.
MsSqlToAccess is a software that export Sql Server query results to Access.
Export Sql Server Query Results To Access – 4 Steps
Click Import – Import From Query button.
1. Show “Import Form Query” Form, input query, click “Get Fields” button.
2. Config target table and “Save Type”.
3. Config Fields.
4. Click Import button, Show export progress.
More about MsSqlToAccess – the tool to export SQL Server data to Access.