Export access base to mysql base

Networking/Security Forums -> Databases

Author: EricaRowletLocation: US PostPosted: Sat Aug 09, 2008 4:11 pm    Post subject: Export access base to mysql base
    ----
Hi everyone,

I need to update on a regular basis an access database with new data. This database can be viewed and manipulated by everybody on the local net of my company.
What I would like to do is to export the content of this access database in a mysql database two times a week.

Simply put I would like to update the mysql database with the data coming from the access database.

How can I do it ?

Author: BluePass PostPosted: Mon Aug 11, 2008 4:40 pm    Post subject:
    ----
One way that I am aware of but which might be a little time-consuming is to export each table into a CSV file. After that MySQL handles CSV files very well; you can simply load the files one by one.

I'm not very familiar with Access, so I'm not sure whether it has a database dump or something like that so you don't waste your time exporting each table. With MySQL you could always make a script to load each table into the database to automate the process a little.



Networking/Security Forums -> Databases


output generated using printer-friendly topic mod, All times are GMT + 2 Hours

Page 1 of 1

Powered by phpBB 2.0.x © 2001 phpBB Group