Does anyone know of a good software that can convert Access files to be compatible with MySQL?
Any suggestion would be appreciated.
An MDB file is a fairly complex structure. What parts of the mdb file?
Tables and data?
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.
Last edited by loquin; 09-05-07 at 18:08.
"Lisa, in this house, we obey the laws of thermodynamics!" - Homer Simpson
"I have my standards. They may be low, but I have them!" - Bette Middler
"It's a book about a Spanish guy named Manual. You should read it." - Dilbert