I have written some code in VB.NET which pulls about 20,000 records from a DB2 table and then populates an excel sheet. I am using a dataset which I am passing around to the various procedures.

When I populate the excel sheet, I simply loop thru the dataset record by record/column by column and insert each row into the sheet. This works fine, but it takes a long time. When I used to code in VB6, I would create a collection class which would be a mirror image of the data in the table, pass that around and use that to populate the excel sheet.

Is there anyway I can just dump the entire dataset into excel and not have to worry about looping thru each row?

Any suggestions?