MySQL Workbench connect to MS Access
You can use MySQL Workbench to connect and migrate your schema/data from MS Access to mySQL.
First you need to configure an ODBC Data Source:


Click Start, and then click Control Panel.
In the Control Panel, double-click Administrative Tools.
In the Administrative Tools dialog box, double-click Data Sources (ODBC). The ODBC Data Source Administrator dialog box appears.
Click User DSN, System DSN, or File DSN, depending on the type of data source you want to add. Click Add.
Select the driver that you want to use, and then click Finish or Next.
Follow the instructions and enter the required connection information in any dialog boxes that follow.


Back on MySQL Workbench: Use the menu Database &gt; Migrate and select the ODBC data source you've created to use as source for your job.