Back to the original excel question...I got the:
Response.ContentType = "application/vnd.ms-excel"
to work, but it doesn't do what I need. I need the excel file to be pre formatted so charts and graphs are automatically created.
Is it possible run queries on an asp page and send the data to specific cells in an excel file that has already been created?