Saving results as Excel
I'm working on a "Classic ASP" page in which the users will be querying a database to show particular clients with certain associations. The customer would like to be able to save their results as an Excel spreadsheet on their own computer to refer back to. (There are a lot of fields from which to choose and remembering how they go a certain set of names is nearly impossible.)
I've been searching the web trying to figure out how to do this, but haven't had any luck. Could someone please help me? How do I save the resulting recordset as an Excel spreadsheet? And I suppose that along with that, the other question would be: How do I display the records as an Excel spreadsheet?
Chris
|