thelinuxlink.net

Easy to do now with this freeware app:
http://www.bullzip.com/products/msa2mys/info.php

An this:
http://dev.mysql.com/downloads/migratio ... t/1.0.html

wow -- this looks sweet. I have an Access db at work that I detest and would love it get it over to mysql. thanks for these links. Has anyone tried them out?

P.S. I like the Iron Maiden avatar, Pat. Powerslave, right? I had that circa 1984 I believe.

Chess wrote:wow -- this looks sweet. I have an Access db at work that I detest and would love it get it over to mysql. thanks for these links. Has anyone tried them out?

P.S. I like the Iron Maiden avatar, Pat. Powerslave, right? I had that circa 1984 I believe.

Well, I haven't used any of those but there is a package called mdb tools that I have been using with great success for quite a while now to yank data out of client-supplied db's so that I could use it. You can find info here: http://mdbtools.sourceforge.net/

MDB-Tools lets you use Access which is crap. Why will you want to mantain Access databases with limited tools. I would just rather use a real database in MySQL.

Chess wrote:wow -- this looks sweet. I have an Access db at work that I detest and would love it get it over to mysql. thanks for these links. Has anyone tried them out?

I have, and it works great.