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

Are you using http://php.net/fgetcsv Cuz if you're not, you're gonna go nuts trying to work out the CSV minutia I think CSV musta been invented by Microsoft. It's got that MS feel to it... On Tue, March 21, 2006 4:19 pm, Brian Anderson wrote: > The only other thing that I can think to do is to try locally write a > .sql file and ftp that for updating because MS Excel format csv is > making me want to kill myself. > > -Brian > > 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