Exporting data to XLS

[Johan Lombaard]

I need to upgrade an app to allow users to export data to Excel (currently it allows for .csv). Does anybody know of a component that can be used for this ( I'd rather not automate Excel if I don't have to ) ?

Johan Lombaard Only two things are infinite, the universe and human stupidity, and I'm not sure about the former - Albert Einstein

[pmarfleet]

Do a search on Google or this site for 'JET OLEDB Excel' and you'll find plenty of results relating to your question.

Paul Marfleet "No, his mind is not for rent To any God or government" Tom Sawyer - Rush

[Prateek G]

Response.ContentType = "application/ms-excel"; Response.AppendHeader("Content-Disposition", "attachment; filename="+fileName+".xls"); Response.End();