I have been exporting data from access tables into MySQL database. The process is pretty straight forward. Export your access database as a text file. The detault options will give you a file delimited with ',' and text fields enclosed in '"'. Now simple use the load infile command with the options delimited with ',' and optionally enclosed with '"'. This imports the table in MySQL database perfectly.
Hope this works for you.
------------------
Anish Modi
Infotech World
India