Access to mySQL migration

Hey everybody. I just set up mySQL on my home comp, and it seems to be working alright, but by dealing with the command prompt interface it is dawning on me that perhaps this isn’t the most efficient way to set up my project.

I am doing a database for a toy store, and they have a large inventory. Ideally, I’d like to do the database in Access (or any other GUI driven app.) and then migrate it to a mySQL database.

I’ve read this is possible by exporting the access file as another database format and then linking it to the mySql database, but I have no idea where to start on this.

Does anybody have a solution/tutorial?

I either need a way to migrate an access database to mySQL or a good GUI that can create a mySQL database. Otherwise I’m stuck doing tons of inventory work on cmd.exe.


Thanks to all who help,