How to export excel from dataset

Ray · Oct 25, 2005

Hi,
Now, I would like to export data to excel from sql server. Is there any
easy way to export to excel from dataset?
Thanks,
Ray

Ken Tucker [MVP] · Oct 25, 2005

Hi,

I prefer to create an xml spread sheet and transform it to an xls.
Here is an example of how to do it. The sample is for asp.net app but the
method will work with a windows forms app.

http://support.microsoft.com/default.aspx?scid=kb;en-us;319180

Ken

How to export excel from dataset

Ray

Ken Tucker [MVP]