MS Access to MySQL (not migration, just updates)

[clrockwell]

Hello,

We have a local MS Access database with customer information in one table and a php/mysql based web site. Currently, we manually make a text file and upload it every so often (only a few fields from Access). We would like for this process to be automated (i.e. once a week mysql updated with access info), and I was wondering if any one has done this or has any ideas on best ways to do it. I know that a simple program will convert the data for us, but what about uploading it remotely. We have SSL access only on our windows server.

Thanks much for any help, and this seems to be a great forum!

Chris

[mattyblah]

either a cron job or a scheduled task should do the trick. web services would be ideal if you cant control both source and destination, but if you can there is probably a very easy way...

[shumaker212]

Take a look at this page, may be this will help you.

Go Here : http://www.dbload.com