Hi all,

I wish to offer the results froma query in an excel format (i presume maybe comma delimitated) for which the user can download.

How do I do this?

Can I avoid physically creating a file on the server? I suppose in my vagueness I could be asking if it is possible to create something like a comma delmitated record set that the user can downlaod????


cheers

Perhaps add the ability for the user to download a CSV file (which does NOT need to be created on the server with FSO although that is a possibility too) which can easily be opened in Excel.

Puzzle 5 Not much different from other solutions by Manohar Kamath posted 1/12/99
http://www.asp101.com/puzzles/puzzle5_s7.asp

Puzzle 5 "Write delimited data to browser window" by Kirk Lockhart posted on 12/21/98
Write the data in plain text to the browser window, and the user can save the results as a plain text file and then import the data into Excel or whatever application they want.
http://www.asp101.com/puzzles/puzzle5_s1.asp

Creating the Excel File Server Side
http://www.greggriffiths.org/webdev/...erverside.html
Uses FSO to create a .csv file.

Thanks very much.
I am looking into it now.
steve