RE: [PHP-DB] MySQL to EXCEL?
| From: | Ed Lazor | Date: | Tue, 17 Aug 2004 20:55:29 +0000 |
| Subject: | RE: [PHP-DB] MySQL to EXCEL? | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-35755@lists.php.net to get a copy of this message | ||
> -----Original Message-----
> either output the data as a csv which you are doing (on windoze name
> the file with a .csv extension) or take a look at
> http://pear.php.net/package/Spreadsheet_Excel_Writer
I have another option that might work for you also. Go to MySQL's website
and grab their ODBC driver and use that to pull data directly into Excel.
That's what I do and the end result tends to be a lot cleaner than going
through cvs or other MySQL exports.
-Ed