By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,665 Members | 2,334 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,665 IT Pros & Developers. It's quick & easy.

DataSet to excel?

P: n/a
What is the most efficient way of transforming DataSet to excel spreadsheet?
Jul 21 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
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" <Pa*********@discussions.microsoft.com> wrote in message
news:18**********************************@microsof t.com...
What is the most efficient way of transforming DataSet to excel

spreadsheet?
Jul 21 '05 #2

P: n/a
Hi Ryan

the link u hv posted is not working.

"W.G. Ryan eMVP" wrote:
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" <Pa*********@discussions.microsoft.com> wrote in message
news:18**********************************@microsof t.com...
What is the most efficient way of transforming DataSet to excel

spreadsheet?

Jul 21 '05 #3

P: n/a
I just tried it and it's up now. Give it another try...

--
W.G. Ryan MVP (Windows Embedded)

TiBA Solutions
www.tibasolutions.com | www.devbuzz.com | www.knowdotnet.com
"Job Lot" <Jo****@discussions.microsoft.com> wrote in message
news:49**********************************@microsof t.com...
Hi Ryan

the link u hv posted is not working.

"W.G. Ryan eMVP" wrote:
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" <Pa*********@discussions.microsoft.com> wrote in message
news:18**********************************@microsof t.com...
What is the most efficient way of transforming DataSet to excel

spreadsheet?

Jul 21 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.