On 8 November 2011 18:31, Ron Piggott <ron.pigg...@actsministries.org> wrote:
> What is the preferred method used to export mySQL to Excel within the context 
> of PHP?  I have looked on Google and found a wide variety of options.  Ron
> Ron Piggott

If the mysql server is set to allow remote access, then you could use
ODBC and Excel to grab the data directly.

Alternatively, if you have SSH or some sort of tunnelling capability,
then with the tunnel in place, it would look like a local connection
and again, ODBC with Excel could be your answer.

I use NaviCat Lite to connect to mysql servers running inside Amazon's
cloud services.

I also Putty to create the tunnel and map the connection to allow the
GoodData client to gather data from the mysql server for further
reporting at GoodData.

Richard Quadling
Twitter : EE : Zend : PHPDoc : Fantasy Shopper
@RQuadling : e-e.com/M_248814.html : bit.ly/9O8vFY : bit.ly/lFnVea :

PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to