uploading data from access to mysql

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
peloke
Forum Newbie
Posts: 2
Joined: Mon Jan 13, 2003 1:41 pm

uploading data from access to mysql

Post by peloke »

I have a php site with a mysql backend. I need to create something that will upload data from an access db on the users machine to the mysql db on the server. How can I do this. If not with php then what can I use?

Thanks,
Eddie
User avatar
BDKR
DevNet Resident
Posts: 1207
Joined: Sat Jun 08, 2002 1:24 pm
Location: Florida
Contact:

Post by BDKR »

Can you dump your access data to a delimited file of some sort?

Cheers,
BDKR
peloke
Forum Newbie
Posts: 2
Joined: Mon Jan 13, 2003 1:41 pm

Post by peloke »

I could but I want to create something so all my users have to do is click a button and their data is uploaded, I don't want them to have to export it, then upload it.

Thanks,
Eddie
hedge
Forum Contributor
Posts: 234
Joined: Fri Aug 30, 2002 10:19 am
Location: Calgary, AB, Canada

Post by hedge »

It seems to me that you will need to upload the mdb file, open it using odbc and then push the data into mysql.

This is easy if the mdb file is small and you don't need to deal with 'differences' ie. this assumes the mdb file is re-created each time they upload it.
Furtim
Forum Newbie
Posts: 1
Joined: Thu Jan 16, 2003 2:23 am

Tool available..

Post by Furtim »

Hello,

There's a slick tool named MySQL-FRONT that will upload from an MS Access file to a MySQL database. I'm using this right now with the same environment.

Here's the download URL:

http://mysqlfront.sstienemann.de/

G'luck!
Furtim
Post Reply