MsSqlToAccess - MS SQL Server to Access »
Click "Wizard - Export All Tables" at task dialog.

then show the wizard.
1. Select tables.

2. Select Access file.

3. Export.

For repeatable task, you can click "Save Session" button to save config, then run it next time. see also: Save and load session.
MsSqlToAccess is a data conversion tool that helps DBA and database programmer export MS SQL Server data to Access.
30-day free trial
US$79.00