Greetings,

Well, as the subject of this post says, I want to convert a microsoft access database into a MySQL database. I'm already running Ubuntu 6 server with a LAMP installation. The MySQL server is already up and running and I've created some test databases. The Access database is located on a Windows server.
I have full permissions to the Access database and the MySQL database. I'd like the migration to be as simple and painless as possible. Any recommendations on free tools to use?

Thank you for your time,

*Nick*

You'll find some instructions on this page http://www.kitebird.com/articles/access-migrate.html to help you.

export your access data to csv format and then load the csv file to my sql using "load data" command.