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

2006-03-23 Thread Robert Cummings
On Thu, 2006-03-23 at 21:30, Richard Lynch wrote: > 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... Taint anyways... http://support.microsoft

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

2006-03-23 Thread Richard Lynch
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 t

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

2006-03-23 Thread Richard Lynch
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 h

RE: [PHP] Advice updating MS Access data to remote MySQL host that only allowslocal access

2006-03-23 Thread Richard Lynch
There is, or used to be, an MS-Access MySQL synchronizer package "out there" Haven't seen it mentioned in years now, but maybe I just wasn't paying attention. Try searching for it: info.com/MS-Access MySQL synchronize On Tue, March 21, 2006 4:00 pm, Brady Mitchell wrote: >> -Original Messag

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

2006-03-21 Thread Chris
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 anyo

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

2006-03-21 Thread Brian Anderson
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

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

2006-03-21 Thread Brian Anderson
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 pe

RE: [PHP] Advice updating MS Access data to remote MySQL host that only allowslocal access

2006-03-21 Thread Brady Mitchell
> -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 h