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@xxxxxxxxx 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
-- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
