I'm designing a web application for a team that is currently tracking all of their data in a Microsoft Access database. The new database will be stored in mySQL, but I don't know enough about Microsoft Access to be certain that I'm doing things correctly.
Is there a tool or procedure that exists that will quickly create all the proper tables in mySQL and transfer all the data from Microsoft Access that does everything correctly?
This might help you; the article is old, but I believe it should still be relevant.
http://www.kitebird.com/articles/access-migrate.html
(By the way; this was a high relevance search result from Google; did you try using Google to search for articles, and if so, why was this article not sufficient?)
I Have a little script using mdbtools. se Access DB5 to MySQL automatically
The MySQL GUI Administration Tools have a Migration toolkit. I've never used it, but it looks like MS Access is an option to migrate from.
Good luck!
Hmm. I have Access 2003 and am running MySQL (to support web work on my laptop). I just went into an Access back end MDB and highlighted a table and chose EXPORT from the file menu and then chose ODBC as the type of target database, and chose the DSN for one of my MySQL databases. I then clicked OK, and low and behold, when I open up phpMyAdmin, there's the exported table in the MySQL database.
In other words, from Access, this is very simple.
It can probably be scripted from Access with DoCmd.TransferDatabase using the appropriate connect string.
Theres a new query tool that can work with different kind of databases, its still a beta, but its working fine.
From the site :
...it’s a generic interface to your data. Any data. If it can be shown in a tabular format, we can work with it. Be it in SQL Server, Microsoft SSAS, MySQL, text files, Via OLEDB or ODBC, you can easily get to it and do whatever it is you need to do with your data.