I am using an Access database and ASP code. I would like to build an Excel speadsheet based upon a query and save it in a file. How can I code this in ASP.
Read this and the related links:<BR>http://support.microsoft.com/support/kb/articles/Q260/2/39.ASP
Thanks for the reply, but I do not want to display results in Excel but instead save query results as an Excel spreadsheet.
OK, well build up the page in exactly the same way as described in the article and save it as a .Xls file with FSO. Excel will work out what to do, and will open it without prompting the user.