Thread: How to Transfer an Excel Range to an ADO.Net DataSet or DataTable in VB.Net?
View Single Post
  #2   Report Post  
Posted to microsoft.public.dotnet.framework.interop,microsoft.public.dotnet.languages.vb,microsoft.public.excel.programming
rowe_newsgroups rowe_newsgroups is offline
external usenet poster
  
Posts: 1
Default How to Transfer an Excel Range to an ADO.Net DataSet or DataTable in VB.Net?
You handle this the same way you handle other data sources. First get
your connection string from www.connectionstrings.com and then proceed
to use ADO.NET to connect and read from the excel file.

Thanks,

Seth Rowe


TCook wrote:
Hey All,

I've seen lots of stuff regarding pumping data into Excel from .Net but
haven't found anything for the reverse.

Does anyone have a snippet, article ID, etc. demonstrating how to take a
range object and pump that data into an ADO.Net DataSet?

Thanks,

TC

Reply With QuoteReply With Quote