leezard Posted July 15, 2003 Posted July 15, 2003 anyone point me to some links or something that can help me convert an access database to sql? Quote
borfast Posted July 15, 2003 Posted July 15, 2003 Export your database as "Comma Separated Values" and then, using phpMyAdmin, import it into MySQL. Quote
stevevan Posted July 16, 2003 Posted July 16, 2003 I found a nifty little program that helped me out a while ago. Check out this link: msa2mys I had to do a little rewriting when I used it but it saved a WHOLE bunch of typing! Quote
surefire Posted July 16, 2003 Posted July 16, 2003 Stevevan, 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. Quote
Lianna Posted July 16, 2003 Posted July 16, 2003 ...and another nifty one: use MyODBC 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). Schmeazzzzzy. PM me if you need he lp setting up the ODBC params. Quote
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.