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?
Convert it:
Search google for "convert access to mysql" and you'll find tons of
results - some free, some not.
-----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
--
Postgresql & php tutorials
http://www.designmagick.com/
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
