I'm looking for some sort of app, tool, macro or other that would let me convert an Access db into a mySQL database.
| SitePoint Sponsor |





I'm looking for some sort of app, tool, macro or other that would let me convert an Access db into a mySQL database.
Adobe Certified Coldfusion MX 7 Developer
Adobe Certified Advanced Coldfusion MX Developer
My Blog (new) | My Family | My Freelance | My Recipes


You can use AccessDUMP, that converts the Access DB into a usable SQL schema dump. AccessDUMP is a free GUI-based application, and can be downloaded here:
http://www.intranet2internet.com/public/default.asp
Once you have converted the Access database to an SQL schema file, then you can use phpMyAdmin to upload the file, using the "Run SQL query/queries on database - textfile" feature on your phpMyAdmin database table listing page.
Bookmarks