• RSS
  • Twitter
  • FaceBook

Security Forums

Log in

FAQ | Usergroups | Profile | Register | RSS | Posting Guidelines | Recent Posts

Export access base to mysql base

Users browsing this topic:0 Security Fans, 0 Stealth Security Fans
Registered Security Fans: None
Post new topic   Reply to topic   Printer-friendly version    Networking/Security Forums Index -> Databases

View previous topic :: View next topic  
Author Message
EricaRowlet
Just Arrived
Just Arrived


Joined: 11 Jul 2008
Posts: 0
Location: US

Offline

PostPosted: Sat Aug 09, 2008 4:11 pm    Post subject: Export access base to mysql base Reply with quote

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 ?
Back to top
View user's profile Send private message
BluePass
Just Arrived
Just Arrived


Joined: 23 Mar 2008
Posts: 0


Offline

PostPosted: Mon Aug 11, 2008 4:40 pm    Post subject: Reply with quote

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.
Back to top
View user's profile Send private message
Display posts from previous:   

Post new topic   Reply to topic   Printer-friendly version    Networking/Security Forums Index -> Databases All times are GMT + 2 Hours
Page 1 of 1


 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum

Looking for more Windows Networking info?

Sign up to the WindowsNetworking.com Monthly Newsletter, written by Enterprise Security MVP Deb Shinder, containing news, the hottest tips, Networking links of the month and much more. Subscribe today and don't miss a thing!
View a sample newsletter.

Become a WindowsNetworking.com member!

Discuss your Windows Networking issues with thousands of other Windows Newtorking experts. Click here to join!

Community Area

Log in | Register

Readers' Choice

Which is your preferred data recovery solution?

Follow TechGenix on Twitter