Access to mySQL migration

[El Phantom]

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.

:hangover:

Thanks to all who help,

--EP

[Jubba]

This seems to be what you want: http://www.topshareware.com/Excel-to-MSSQL-download-7402.htm

also, try searching google for "access convert mysql" and you'll get a buttload of hits. :)

[andrthad]

mySQLFront is a nice GUI for mySQL. There is also something called PHPAdmin. I think mySQLFront can migrate an Access Database to mySQL using ODBC. I am looking into doing the same thing soon. Let me know how it goes.

Download from here.

http://mysqlfront.venturemedia.de/index.php?act=ST&f=2&t=328&

[El Phantom]

Thanks guys. I'll check these out when I get home tonight.

Any more?

*Edit* For my purposes, i think PHPmyAdmin will work fine.
Thanks guys!


--EP