Display query result and export to excel using classic asp

Question

I'm working on a small project regarding classic ASP and sql server.

I have a drop down menu where the user can enter name, last name, etc. and it will create a query based on that and create a table displaying the result.

What I want to add is the option to export to excel after the table is created. I've looked at other tutorials but they all use the simple Select * from table rather than a query based on user input.

can anyone help on this?

Answer 1

add

response.contenttype ="Application/vnd.excel"
response.addheader "Content-Disposition", "attachment; filename=excelDatei.xls"

and the browser opens the save/open/cancel dialog...

is that what you want?