uploading to MySQL

P

Peter Connolly

Hi,

I have an application written in Access, running on some PCs at a clients.

On a regular basis, I will need to upload the data from the Access database
to MySQL. The obvious solution to me would be ODBC, but I get ODBC
connection failures after about 100 records - the connection doesn't seem
very robust.

What, in your opinion, would be the best way to get this data across,
bearing in mind that the users need me to provide a turnkey solution. I know
that CSV would help, but that will require lots of help everytime the data
is uploaded to mySQL.

Regards,

Peter Connolly
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Hitting the limits with large table in Excel containing 1 millionrecords. What is the best option fo 2
Access for MySQL data reports only 5
add password to circumvent mysql connector pop-up 3
Connecting to MySQL at Startup 4
ODBC Connector to MySQL server 2
Local Mysql Info 1
Exporting and Zipping Files with Access VBA 4
Connecting to an external mysql database 3

Top