First, you need and install MysqlToAccess.
MysqlToAccess is a data conversion tool that helps DBA and database programmer export Mysql data to Access.
Export Mysql 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 MysqlToAccess – the tool to batch export MySQL data to Access.