> -----Original Message----- > I wonder if anyone has any ideas? As I can't just run an > update locally > and connect to the remote MySQL host, I was scheduling a > periodic export > of an access table to csv format, ftping it to the server, and then > running an update script on the remote host (simplehost.com). It just > seems convoluted, and frought with difficulties. There has to be a > easier way to update the transaction status table? First schedule an automatic upload of the .mdb file to the server. (Not sure how to do this, google is your friend for this part.) Then write a PHP Script that will: 1 - Connect to the Access DB and query for the data you need 2 - Insert that data into the mySQL database Then schedule a cron job to run the script at a set time each day (or whatever frequency you need). Take a look at the ADODB Class (http://adodb.sf.net) for connecting to MS Access from PHP. I used it once for a project where I had to use an Access DB and it was actually pretty smooth. I now use ADODB for all of my DB connections. :) HTH, Brady -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
