You need MyODBC which you can download from http://www.mysql.com.
There are certainly more knowledgable people here who can explain it better,
but when I was trying to figure this out last week I found that the
documentation for MyODBC was not great, so here's how I did it, hopefully it
will work for you. Unfortunately you need to do some configuring first, but
once it is done it seems to run fine.
1) Unzip the MyODBC archive to any folder , I called mine MyODBC
2) Go to this folder and find the setup application and run it.
3) Choose MySQL from the list of ODBC drivers (This should be the only one
4) Click on OK.
5) You will probably get another dialog called Data Source, you can cancel
this by clicking on close.
6) Go to Control Panel and find something that looks like "DataSource
(ODBC)". I am using Win2000 and I found this in Admin Tools. Once you have
found this run it.
7) Select System DSN from the tabs and click on ADD and scroll down the
available list of drivers until you find MySQL. Selec this and click on
8) Select a Data Source Name (DSN) such as "MySQL database" or whatever you
9) Add the details of your MySQL server, such as host name, user name and
password. Be sure to include the port of 3306. (It took me ages to work this
10) Click OK.
Thats it, you are ready to roll. Goto to MS Access and select export. From
the dialog of database types select ODBC (usually at the bottom). You will
then need to select the DSN you have set up, ie MySQL Database and you are
away, it should tranfer all of the data. You can also do the same in reverse
to import data from MySQL to Access.