Automatic Acccess to mySQL process?

is there an application that will update sql db's from access?

[tekjnke]

Hello,

I have a potential client that currently has his data in an MS Access DB (from a point of sale application) and we would like to put the db online.

I was wondering if here was any application that would take the access db info, and translate it to mySQL and upload it to the server, etc. The server would be running *nix, but possibly NT.

Thanks.
-Tekjnke

[sun818]

If you want to DIY, I would add an item on the Task Scheduler to kick off a job that would create an export of the AccessDB. FTP this file to the web site. Then there would be a scheduled cron job that would process the export file into the mySQL database. Take a look at page 4 of this PDF [nusphere.com]. They discuss some migration scenarios for your situation.

Thanks for your question, you've inspired me to think about how I can migrate my AccessDB to mySQL too. :)

[tekjnke]

Interesting, thanks. I will have to create some test information and see what I can do with that.

If you think of anything else, let me know. :)
-Tekjnke

[jatar_k]

I have done it the opposite way as well. I had an online mysql db that had to be synced to a desktop pc in an access db. I had it outfile the info every morning and I would email to the person.

I had written a little vb app that would grab the textfile and update her access db, worked pretty well.