anyone point me to some links or something that can help me convert an access database to sql?<!--content-->
Export your database as "Comma Separated Values" and then, using phpMyAdmin, import it into MySQL.<!--content-->
I found a nifty little program that helped me out a while ago. Check out this link:<br /><br /><a href="http://www.bullzip.com/products.php" target="_blank">msa2mys</a><br /><br />I had to do a little rewriting when I used it but it saved a WHOLE bunch of typing!<!--content-->
Stevevan,<br />You saved me the trouble of finding that link that I gave you when you had this same issue. This is what makes TCH so great. Everyone helps out and passes info along.<!--content-->
...and another nifty one: use <a href="http://www.mysql.com/products/myodbc/" target="_blank">MyODBC</a> to directly connect to your MySQL db from within Access, then just Export from Access. The only thing I had to do after was reestablish the indices (which was probably a stupid error on my part in the Export setup).<br /><br />Schmeazzzzzy. PM me if you need he <img src="http://www.totalchoicehosting.com/forums/style_emoticons/default/cool.gif" style="vertical-align:middle" emoid="B)" border="0" alt="cool.gif" /> lp setting up the ODBC params.<!--content-->
Export your database as "Comma Separated Values" and then, using phpMyAdmin, import it into MySQL.<!--content-->
I found a nifty little program that helped me out a while ago. Check out this link:<br /><br /><a href="http://www.bullzip.com/products.php" target="_blank">msa2mys</a><br /><br />I had to do a little rewriting when I used it but it saved a WHOLE bunch of typing!<!--content-->
Stevevan,<br />You saved me the trouble of finding that link that I gave you when you had this same issue. This is what makes TCH so great. Everyone helps out and passes info along.<!--content-->
...and another nifty one: use <a href="http://www.mysql.com/products/myodbc/" target="_blank">MyODBC</a> to directly connect to your MySQL db from within Access, then just Export from Access. The only thing I had to do after was reestablish the indices (which was probably a stupid error on my part in the Export setup).<br /><br />Schmeazzzzzy. PM me if you need he <img src="http://www.totalchoicehosting.com/forums/style_emoticons/default/cool.gif" style="vertical-align:middle" emoid="B)" border="0" alt="cool.gif" /> lp setting up the ODBC params.<!--content-->