Re: DataSet to excel?

From: W.G. Ryan eMVP (WilliamRyan_at_gmail.com)
Date: 12/29/04 

Date: Wed, 29 Dec 2004 17:42:22 -0500

Fill the dataset with a DataAdapter setting the AcceptChangesDuringFill to
false. Then use the OleDbDataAdapter to Update it - the connection string
is available at http://www.connectionstrings.com/ under the Excel section.
You can also use the WriteXML method and then use Com INterop to pull it in.

HTH,

Bill 

-- 
W.G. Ryan, MVP
www.tibasolutions.com | www.devbuzz.com | www.knowdotnet.com
"Pankaj Banga" <PankajBanga@discussions.microsoft.com> wrote in message
news:18613892-227F-4397-BB09-06F2EC5ADB52@microsoft.com...
> What is the most efficient way of transforming DataSet to excel
spread***?