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,
How to export access database to MySql/PHP?
Moderator: General Moderators
- RobertGonzalez
- Site Administrator
- Posts: 14293
- Joined: Tue Sep 09, 2003 6:04 pm
- Location: Fremont, CA, USA
- RobertGonzalez
- Site Administrator
- Posts: 14293
- Joined: Tue Sep 09, 2003 6:04 pm
- Location: Fremont, CA, USA
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.
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.
- RobertGonzalez
- Site Administrator
- Posts: 14293
- Joined: Tue Sep 09, 2003 6:04 pm
- Location: Fremont, CA, USA