Re: Advice updating MS Access data to remote MySQL host that only allowslocal access

You don't. You run PHP on the Windows box with the mdb file, and set up a way for the two boxes to talk to each other. Or you convince somebody somewhere just how bad MS-Access is and abandon it entirely :-) On Tue, March 21, 2006 4:05 pm, Brian Anderson wrote: > Yeah, I thought of that, but how do I connect to a mdb file on a linux > server that doesn't have odbc installed? > > 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