Page 1 of 1

How to export access database to MySql/PHP?

Posted: Fri Oct 06, 2006 1:52 pm
by gma216
I have a access database that i would like to export into a MySql database weekly. What is the easiest and most effective way to do this. I still want to keep the access database and make any changes there, but just would like to export it to an online MySql database.

Any input would be much apprieciated.

Thanks,

Posted: Fri Oct 06, 2006 1:53 pm
by RobertGonzalez
Are you doing it manually or with code?

Posted: Fri Oct 06, 2006 1:56 pm
by gma216
Manually, well ideally would be just use an export function in Access, and upload that file on the web server compatible for MySql. I dont know if thats possible or not though.

Posted: Fri Oct 06, 2006 1:59 pm
by RobertGonzalez
No, it is not. The only export functionality that Access has in a CSV/Tab Delimited text file. What I have done in the past was to dump the access file as a CSV then use phpMyAdmin to try to import the data. That will probably not work out well (at least it didn't in my experience). I ended up ditching Access in favor of two MySQL databases. One was local (like Access was) and the other was hosted. Syncing can be done by dump/import or by a Sync mechanism like SQLYog offers.

Posted: Fri Oct 06, 2006 2:05 pm
by gma216
Is there any way to keep the acces database and use some other conversion. Because i think our company would want to stay with Access. I've researched online and found a software by Soft Galaxy: http://www.softgalaxy.net/access-mysql/ dont know if this software is any good or not though.

Posted: Fri Oct 06, 2006 2:17 pm
by RobertGonzalez
Never heard of it, but maybe you could try it and let us know how it goes? Just remember to back up early and often.