To write in excel file through ASP

Atempting to display the table contents in the excel file through ASP

[dptsharma]

Giving a brief description what i am exactly doing.

In my ASP, i have created a FileSystemObject inorder to write in .sql file in which i write my Sql queries.
In SQL-Plus, i run this .sql file and get the output written in excel file(through spool command).

Now, my query is- Is there any possible way that through ASP coding i directly get the output of my sql queries in the excel file.
If any idea spread some light regarding it.

[Iguana]

You could always write a file out as a comma separated .csv file - it doesn't give you any formatting though. Excel is normally the default .csv editor. You can even name the file <file>.xls (but when you try and save it in Excel it knows it is a text file)