RE: [PHP] Advice updating MS Access data to remote MySQL host that only allowslocal access

There is, or used to be, an MS-Access MySQL synchronizer package "out there" Haven't seen it mentioned in years now, but maybe I just wasn't paying attention. Try searching for it: info.com/MS-Access MySQL synchronize On Tue, March 21, 2006 4:00 pm, Brady Mitchell wrote: >> -----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 > > -- Like Music? http://l-i-e.com/artists.htm