[thelist] MySQL to Excel Problem

Dougal Campbell dougal at gunters.org
Wed May 1 13:49:01 CDT 2002

On Wed, 1 May 2002, Jay Blanchard wrote:

> [snip]
> /path/to/php_to_excel.php/excel.xls
> [/snip]
> OK, that solves that problem and is easy to implement. The problem I have
> now is creating pivot tables from the information. [....]

I'd probably use an associative array.... I'm in perl mode right now,
and my PHP is rusty, so forgive me for not attempting a code sample. But
that should point you in the right direction, anyhow.

But I'll also toss in another idea.... Have you considered setting up an
ODBC connection to your MySQL server, and just importing the data into
Excel by that route?

Ernest MacDougal Campbell III, MCP+I, MCSE <dougal at gunters.org>
http://dougal.gunters.org/             http://spam.gunters.org/
  Web Design & Development:  http://www.mentalcollective.com/
       This message is guaranteed to be 100% eror frea!

More information about the thelist mailing list