I'm converting ASP to .NET. There is a page in the ASP application that does this: You click on an agent and a month and you get a report of his commission for that month in Excel.

I don't know if looking at the ASP code will help me but I am thinking I have to start from scratch.

So here is my environment: VS 2005, VB.NET, ASP.NET 2.0, Office 2007.

The report is very simple and I have the queries that generate the data, I just need to give the data to Excel and bring the user there to view it.

Googling is finding me plenty of resources but I was hoping people I trust here could point me to the best resource. Because I've found "resources" whose solution was to use Reponse.Write in asp.net code when we all know that that should be RegisterClientScriptBlock !

Thanks.