Exporting data into Excel from ASP

[Anon]

Can anyone help to export/IMPORT a set of record to/from Excel spread sheet.
I should be able to do it from the ASP screen.

LEt me know the feasibility and how it can be done.

Thanks

[Anon]

Well, writing to EXCEL files requires an Com Object. There is a specific binary structure that ASP is not capable of.

However.. you can create a CSV (comma separated value) file which Excel can understand. The format is like this:

row_header,row_header,row_header
value,value,value
value,value,value
etc

[Anon]

There are several ways to accomplish this. You may want to check out the following:
http://www.web-savant.com/users/kathi/asp/samples/tut/Export_to_Excel.asp