Driving Excel from a DataSet



Hi all!

I have a question, and this may be the wrong forum. I have an ADO.NET
dataset that i would like to use to create an excel spread***. I am using
the COM interop excel 11 library, but am running into problems. I also
wonder if rather than trying to 'drive' excel from dot net if i can instead
dynamically generate a .csv file from my dataset and then simply 'drive'
excel to import the csv and create the workbook on its own, rather than
manually specifying all the column names, widths, etc.

Can anyone point me in the right direction, (or to the right forum )

Steve Wooley, MCSE: Security


.