please give me tips or code to convert a dataset to excel sheet

You can use a OleDbDataAdapter http://www.connectionstrings.com/ (Look for
Excel) and then just call Update. Otherwise, you're going to have to use
the Excel Library and walk the sheet, populating a dataset from there. It's
not very complex, just two loops, if you don't know the excel object model
it'sa pain inthe butt. here's an example
http://www.codeproject.com/dotnet/ExportExcelData.asp However if you put in
Excel to DataSet in google, there's quite a few more that are pretty much
ready to go.

HTH,

Bill

--
W.G. Ryan, MVP

www.tibasolutions.com | www.devbuzz.com | www.knowdotnet.com
"venkat" <(E-Mail Removed)> wrote in message
news:8B5A33E6-A17C-445F-9091-(E-Mail Removed)...
> please give me tips or code to convert a dataset to excel sheet
>

Hi Venkat,

I Bill got your request backwards - you want to go from dataset to excel,
not the reverse. Here's a good example:

http://www.dotnetspider.com/technology/kbpages/950.aspx

HTH,

Bernie Yaeger

"venkat" <(E-Mail Removed)> wrote in message
news:8B5A33E6-A17C-445F-9091-(E-Mail Removed)...
> please give me tips or code to convert a dataset to excel sheet
>