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
