How can I export ASP recordset to Excel Spreasheet

[Bwintech]

Hi

Can I export a SQL-Driven recordset directly to a excel spreadsheet, without use of a export wizard - i.e. through ASP code?

Thanks in advance for your help,

Regards,
Brett

 

[TonyU]

[tt]

Sample 1:

http://www.asp101.com/samples/xl.asp

Sample 2:

http://www.4guysfromrolla.com/webtech/022801-1.shtml

​

 

[y2kprawn]

You can cheat, if the local machine has excel installed you can make the HTML page appear in Excel instead of HTML. All you need to do is change

Response.ContentType = "application/vnd.ms-excel"

at the beginning of the file,