I have succesfully create export from my database to Excel file using
Response.ContentType = "application/vnd.ms-excel"
command.

It's kinda interesting, but I have three questions more which I don't know how to realize.

1. Is it possible instead of xls, export as compressed .zip file?
2. Is it possible to Freeze first row, freeze option in Excel stay "always on"?

3. How to add some special code which I would write in Excel?

Thanks.

may you be so kind to explain the exact steps to export a database to excel? thanks

Just create standard table and all records in this table you want to show.

And add this in the begginig of the page:

Response.ContentType = "application/vnd.ms-excel"
Response.AddHeader "content-disposition", "attachment; filename=filename.xls"


That's all.

If you export the data from the database to excel file, you can control to keep or remove the first row.

How to do that, I'm generating table in ASP code from MS Access database using above mentioned commands.

All I want is to freeze first row and somehow compress excel file in the fly (.zip).
Uncompressed .xls file has 300 kB and compressed zip only 20 kB, so this will be very good option for my web page.

Thank you.