First, you need download and install MysqlToAccess.
MysqlToAccess is a data conversion tool that helps DBA and database programmer unload data from Mysql schema into Access.
Unload Data From Mysql Schema Into Access -3 Steps
Click “Wizard – Export All Tables” at task dialog.

then show the wizard.
1. Select schema and tables.

2. Select Access file.

3. Export.


