I am trying to create a small little reporting app in asp for our sales guys and have the queries going to a html table. I was wondering how I could add a button so my users could download the recordset to there computers.

If you want to display the data in excel format on HTML page, you need to add the following code at the beginning of your asp code:

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

And also you need to remove all templates including header, footer, left or right bar. In this ASP file, you only use the table. That's it.