Importing MySQL Databases to MS Access

Open the import dialog by selecting File -> Get External Data -> Import... Choose the file type "ODBC Database".
Select the "Machine Data Source" tab and select the MyODBC DSN you've created for your MySQL database.
Select the table to import and click "OK".