How to export excel from dataset

[Ray]

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]]

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