Re: MySQL to EXCEL?

I don't know how you have it setup. But you can create a XLS file on the fly using PHP.... By using header... header("Content-Type: application/vnd.ms-excel"); header("Content-Dispostion: attachemnt; filename='Project.xls'"); header("Pragma: no-cache"); header("Expires: 0"); Then just echo your results from your query, like normal... You have just created a XLS from PHP...Which can be saved to a XLS Workbook... Dan On Aug 17, 2004, at 4:33 PM, h.dudeness@gmail.com wrote:

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.

I was not sure that this was a mysql db.

sorry for the second email, I see now in the subject of the email it is mysql, stupid me. You could also try an excel com object to do this. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php