exporting a sql result to excel file

[sherrysun]

Hello,
I wonder if anyone could help me out on this problem: I am trying to create a "report writer" with php. Data is stored in ms_sql server. I am very new to php. My idea is to retrieve data with a query and export the result to excel file to client side. What is the php command to export to a excel file? thanks in advance.

sherry

[Anon]

Write a template that creates a page that is a comma-delimited file of mime type application/octet-stream. Download the page, and import into the spreadsheet.

[sherrysun]

thank you and I will try that.
sherry