I've received a lot of interest around a previous entry I made about transforming a .NET DataSet to an Excel workbook.  While I did mention that it was possible to transform a DataSet with multiple tables to a workbook with multiple worksheets, my previous example did not demostrate this - it focused on the handling of the DateTime data type in Excel ...

Attached is a zip file that demonstrates this.  The contained stored procedure can be executed against your copy of the Pubs database, just code your connection string accordingly ...

MultiWorksheet.zip (2.02 KB)