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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux