Re: [PHP] Convert MySQL table into Access or Excell format
> > > the mysql list). Put simply, you can specify which port you want MySQL to > > > use. However if the ISP only allows certain ports, eg SMTP, HTTP, _and_ > > > you're already using those ports, then you're stuck up a creek. > > > > > > Of course you can always ask your ISP to unblock that port. Why are > > > _they_ firewalling _your_ network anyway? > > > > Sorry for the confusing...the "ISP" is the hosting company where my > > client's web site hosted. That's why I need a php solution for this... > > OK, export mysql tables to CSV, import into Access. okay thanks a lot! > > -- > Jason Wong -> Gremlins Associates -> www.gremlins.com.hk > Open Source Software Systems Integrators > * Web Design & Hosting * Internet & Intranet Applications Development * > > /* > Try to be the best of whatever you are, even if what you are is no good. > */ > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Convert MySQL table into Access or Excell format
On Saturday 13 July 2002 14:51, Alex Shi wrote: > > the mysql list). Put simply, you can specify which port you want MySQL to > > use. However if the ISP only allows certain ports, eg SMTP, HTTP, _and_ > > you're already using those ports, then you're stuck up a creek. > > > > Of course you can always ask your ISP to unblock that port. Why are > > _they_ firewalling _your_ network anyway? > > Sorry for the confusing...the "ISP" is the hosting company where my > client's web site hosted. That's why I need a php solution for this... OK, export mysql tables to CSV, import into Access. -- Jason Wong -> Gremlins Associates -> www.gremlins.com.hk Open Source Software Systems Integrators * Web Design & Hosting * Internet & Intranet Applications Development * /* Try to be the best of whatever you are, even if what you are is no good. */ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Convert MySQL table into Access or Excell format
Tunnel port 3306 over an SSH connection if you can get an SSH session to open to the remote. On Sat, 13 Jul 2002, Alex Shi wrote: > "Jason Wong" <[EMAIL PROTECTED]> wrote in message > [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > > On Saturday 13 July 2002 13:31, Alex Shi wrote: > > > The thing is that, the MySQL table resides on a remote web server, my > > > client want to download it and access it in Access. > > > > Doesn't matter, ODBC works across a network. > > But what can we do if the ISP closed 3306 port on their firewall? > > > > > -- > > Jason Wong -> Gremlins Associates -> www.gremlins.com.hk > > Open Source Software Systems Integrators > > * Web Design & Hosting * Internet & Intranet Applications Development * > > > > /* > > The young lady had an unusual list, > > Linked in part to a structural weakness. > > She set no preconditions. > > */ > > > > > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Convert MySQL table into Access or Excell format
I seem to remember some Windows application that will do the conversion for you. I believe it's called mysql2access and the other way is access2mysql. IIRC, it's not open/free though. On Sat, 13 Jul 2002, Alex Shi wrote: > The thing is that, the MySQL table resides on a remote web server, my client > want to download it and access it in Access. > > Alex > > > You can also use ODBC (Ships with Acess) to make a DSN connection to > MySQL. > > Access can retrieve data from any ODBC DSN. > > > > Jason White > > > > - Original Message - > > From: "Jason Wong" <[EMAIL PROTECTED]> > > To: <[EMAIL PROTECTED]> > > Sent: Friday, July 12, 2002 9:48 PM > > Subject: Re: [PHP] Convert MySQL table into Access or Excell format > > > > > > > On Saturday 13 July 2002 06:48, Alex Shi wrote: > > > > Hello, > > > > > > > > My client has a website and it support MySQL/PHP. The client want > > > > to download the MySQL tables and then access them in Excell or > > > > Access. So my question is, is it possible to convert MySQL table into > > > > Access or Excell format? Thanks in advance for all answer! > > > > > > archives -> "mysql excel" > > > > > > -- > > > Jason Wong -> Gremlins Associates -> www.gremlins.com.hk > > > Open Source Software Systems Integrators > > > * Web Design & Hosting * Internet & Intranet Applications Development * > > > > > > /* > > > After years of research, scientists recently reported that there is, > > > indeed, arroz in Spanish Harlem. > > > */ > > > > > > > > > -- > > > PHP General Mailing List (http://www.php.net/) > > > To unsubscribe, visit: http://www.php.net/unsub.php > > > > > > > > > > > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Convert MySQL table into Access or Excell format
"Jason Wong" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > On Saturday 13 July 2002 14:00, Alex Shi wrote: > > "Jason Wong" <[EMAIL PROTECTED]> wrote in message > > [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > > > > > On Saturday 13 July 2002 13:31, Alex Shi wrote: > > > > The thing is that, the MySQL table resides on a remote web server, my > > > > client want to download it and access it in Access. > > > > > > Doesn't matter, ODBC works across a network. > > > > But what can we do if the ISP closed 3306 port on their firewall? > > This thread is leading into non-PHP territory (ie you're better off asking on > the mysql list). Put simply, you can specify which port you want MySQL to > use. However if the ISP only allows certain ports, eg SMTP, HTTP, _and_ > you're already using those ports, then you're stuck up a creek. > > Of course you can always ask your ISP to unblock that port. Why are _they_ > firewalling _your_ network anyway? Sorry for the confusing...the "ISP" is the hosting company where my client's web site hosted. That's why I need a php solution for this... > > -- > Jason Wong -> Gremlins Associates -> www.gremlins.com.hk > Open Source Software Systems Integrators > * Web Design & Hosting * Internet & Intranet Applications Development * > > /* > What we do not understand we do not possess. > -- Goethe > */ > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Convert MySQL table into Access or Excell format
On Saturday 13 July 2002 14:00, Alex Shi wrote: > "Jason Wong" <[EMAIL PROTECTED]> wrote in message > [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > > > On Saturday 13 July 2002 13:31, Alex Shi wrote: > > > The thing is that, the MySQL table resides on a remote web server, my > > > client want to download it and access it in Access. > > > > Doesn't matter, ODBC works across a network. > > But what can we do if the ISP closed 3306 port on their firewall? This thread is leading into non-PHP territory (ie you're better off asking on the mysql list). Put simply, you can specify which port you want MySQL to use. However if the ISP only allows certain ports, eg SMTP, HTTP, _and_ you're already using those ports, then you're stuck up a creek. Of course you can always ask your ISP to unblock that port. Why are _they_ firewalling _your_ network anyway? -- Jason Wong -> Gremlins Associates -> www.gremlins.com.hk Open Source Software Systems Integrators * Web Design & Hosting * Internet & Intranet Applications Development * /* What we do not understand we do not possess. -- Goethe */ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Convert MySQL table into Access or Excell format
"Jason Wong" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > On Saturday 13 July 2002 13:31, Alex Shi wrote: > > The thing is that, the MySQL table resides on a remote web server, my > > client want to download it and access it in Access. > > Doesn't matter, ODBC works across a network. But what can we do if the ISP closed 3306 port on their firewall? > > -- > Jason Wong -> Gremlins Associates -> www.gremlins.com.hk > Open Source Software Systems Integrators > * Web Design & Hosting * Internet & Intranet Applications Development * > > /* > The young lady had an unusual list, > Linked in part to a structural weakness. > She set no preconditions. > */ > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Convert MySQL table into Access or Excell format
On Saturday 13 July 2002 13:31, Alex Shi wrote: > The thing is that, the MySQL table resides on a remote web server, my > client want to download it and access it in Access. Doesn't matter, ODBC works across a network. -- Jason Wong -> Gremlins Associates -> www.gremlins.com.hk Open Source Software Systems Integrators * Web Design & Hosting * Internet & Intranet Applications Development * /* The young lady had an unusual list, Linked in part to a structural weakness. She set no preconditions. */ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Convert MySQL table into Access or Excell format
The thing is that, the MySQL table resides on a remote web server, my client want to download it and access it in Access. Alex > You can also use ODBC (Ships with Acess) to make a DSN connection to MySQL. > Access can retrieve data from any ODBC DSN. > > Jason White > > - Original Message - > From: "Jason Wong" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Friday, July 12, 2002 9:48 PM > Subject: Re: [PHP] Convert MySQL table into Access or Excell format > > > > On Saturday 13 July 2002 06:48, Alex Shi wrote: > > > Hello, > > > > > > My client has a website and it support MySQL/PHP. The client want > > > to download the MySQL tables and then access them in Excell or > > > Access. So my question is, is it possible to convert MySQL table into > > > Access or Excell format? Thanks in advance for all answer! > > > > archives -> "mysql excel" > > > > -- > > Jason Wong -> Gremlins Associates -> www.gremlins.com.hk > > Open Source Software Systems Integrators > > * Web Design & Hosting * Internet & Intranet Applications Development * > > > > /* > > After years of research, scientists recently reported that there is, > > indeed, arroz in Spanish Harlem. > > */ > > > > > > -- > > PHP General Mailing List (http://www.php.net/) > > To unsubscribe, visit: http://www.php.net/unsub.php > > > > > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Convert MySQL table into Access or Excell format
You can also use ODBC (Ships with Acess) to make a DSN connection to MySQL. Access can retrieve data from any ODBC DSN. Jason White - Original Message - From: "Jason Wong" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, July 12, 2002 9:48 PM Subject: Re: [PHP] Convert MySQL table into Access or Excell format > On Saturday 13 July 2002 06:48, Alex Shi wrote: > > Hello, > > > > My client has a website and it support MySQL/PHP. The client want > > to download the MySQL tables and then access them in Excell or > > Access. So my question is, is it possible to convert MySQL table into > > Access or Excell format? Thanks in advance for all answer! > > archives -> "mysql excel" > > -- > Jason Wong -> Gremlins Associates -> www.gremlins.com.hk > Open Source Software Systems Integrators > * Web Design & Hosting * Internet & Intranet Applications Development * > > /* > After years of research, scientists recently reported that there is, > indeed, arroz in Spanish Harlem. > */ > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Convert MySQL table into Access or Excell format
On Saturday 13 July 2002 06:48, Alex Shi wrote: > Hello, > > My client has a website and it support MySQL/PHP. The client want > to download the MySQL tables and then access them in Excell or > Access. So my question is, is it possible to convert MySQL table into > Access or Excell format? Thanks in advance for all answer! archives -> "mysql excel" -- Jason Wong -> Gremlins Associates -> www.gremlins.com.hk Open Source Software Systems Integrators * Web Design & Hosting * Internet & Intranet Applications Development * /* After years of research, scientists recently reported that there is, indeed, arroz in Spanish Harlem. */ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Convert MySQL table into Access or Excell format
Hello, My client has a website and it support MySQL/PHP. The client want to download the MySQL tables and then access them in Excell or Access. So my question is, is it possible to convert MySQL table into Access or Excell format? Thanks in advance for all answer! Alex -- --- TrafficBuilder Network: http://www.bestadv.net/index.cfm?ref=7029 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
