Another option might be ursql (http://www.urbanresearch.com/ursql). This
tool has the ability to generate MySQL-compatible CREATE TABLE scripts
from a connected MS Access database. Once the basic CREATE TABLE scripts
are generated, you can easily tweak the data types to your liking.
In my exper
I too am researching how to do this. I've found plenty of products that will
do this, of course, I'd rather do it myself.
here's some links i've found:
http://www.convert-in.com/acc2sqlp.htm
http://ultradev.buzzinet.co.uk/mysql/tutorials/converting_data/index.asp
http://www.winmysql.com/
i hope