Hello, everyone.

Does anyone know of a good software that can convert Access files to be compatible with MySQL?

Any suggestion would be appreciated.

Regards,

An MDB file is a fairly complex structure. What parts of the mdb file?

Tables and data?

Queries?

RI?


I'm not aware of anything that could do VBA, macros, reports or forms.

For simple requirements, possibly this module would suffice. (From within Access, it reads the Access table structure and generates SQL DDL which you can use to recreate the table structure on the server side. Then, you would link your access file to the new tables, and run a query to copy the records from the local table to the server-side table.

I know that Navicat will import Access data into MySQL; I'm not sure as to the scope of what it supports.

HaileyJ,

You can try our newly released DBConvert for Access & MySQL at http://dbconvert.com , which performs tables and data conversion.
As well please look at http://www.dbconvert.com/convert-acc...-web-mysql.php . DBForms from MS Access to PHP + MySQL. It transfers MS Access forms to Ajax based web page driven by mySQL.

Best regards,
Dmitry,
http://dbconvert.com

If you're talking about importing the tables and data from Access to MySQL, i've found that MySQL's own Migration Toolkit does the job without any problems. It's an easy-to-use, step-by-step GUI.

officeman, did you happen to read the thread? like, the post immediately before yours (posted a week ago)