Database converter

[stealth2009]

Is there a free application which can convert a database created from a different to another database (i.e. Access to MYSQL)?

--------------------
Free Software Downloads
Email Notifier with auto-login for Gmail/Yahoo/Hotmail

 

[EagleKeeper]

MySQL can import an MS Access DB

 

[stealth2009]

Thanks I tried it earlier but I could not seem to get it working. I will try it again. Just to share this link which might also be of help to the rest on Access to MYSQL migration http://www.kitebird.com/articles/access-migrate.html .

-------------------------
Free Software Downloads
Email Notifier with auto-login for Gmail/Yahoo/Hotmail

 

[EagleKeeper]

Note that only the data and tables may be imported.

I do not know about macros, querys, reports or forms.
I would expect that only the querys would have a chance. The Macros and Forms/Reports are tied to Access/VBA

 

[Thyme]

I think most just use ODBC to convert so it only gets tables. I've tried them on one with Access subtables and it didn't convert right.

 

[KLin]

Originally posted by: Thyme
I think most just use ODBC to convert so it only gets tables. I've tried them on one with Access subtables and it didn't convert right.

That's how I would do it. Create the tables in MySQL, install the MYsql odbc driver, link the tables within the access mdb file, then import the data via append queries.

 

[stealth2009]

I just got a light application called AccessDUMP. It's a freeware given by a friend. You can easily convert your access db to MYSQL using this tool. Just another option to share with you.

-------------------------
Free Software Downloads
Email Notifier with auto-login for Gmail/Yahoo/Hotmail