Page 1 of 1
uploading data from access to mysql
Posted: Mon Jan 13, 2003 1:41 pm
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
Posted: Tue Jan 14, 2003 2:45 pm
by BDKR
Can you dump your access data to a delimited file of some sort?
Cheers,
BDKR
Posted: Wed Jan 15, 2003 1:47 pm
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
Posted: Wed Jan 15, 2003 4:19 pm
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.
Tool available..
Posted: Thu Jan 16, 2003 2:23 am
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