How to Transfer an Excel Range to an ADO.Net DataSet or DataTable in VB.Net?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

TCook - 02 Nov 2006 06:29 GMT

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 to this Message

rowe_newsgroups - 02 Nov 2006 12:49 GMT

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

> Hey All,
>
[quoted text clipped - 7 lines]
>
> TC

Reply to this Message

Paul Clement - 02 Nov 2006 15:53 GMT

¤ 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?

See the following MS KB article:

How To Use ADO.NET to Retrieve and Modify Records in an Excel Workbook With Visual Basic .NET
http://support.microsoft.com/kb/316934

Paul
~~~~
Microsoft MVP (Visual Basic)

Reply to this Message

TCook - 02 Nov 2006 18:52 GMT

Hey Guys,

I don't think that I was quite clear.

Using a range object, is there a quick way to blast the data into a
datatable?

For example, using a range object, one can dump the data to an array. Is
there a way to do something similar with a range object and a datatable?

Is there a quick way to dump the data from an array into a datatable?

I won't be using connection strings, etc. I will be using range objects.

Thanks & Regards,

TC

> ¤ Hey All,
> ¤
[quoted text clipped - 13 lines]
> ~~~~
> Microsoft MVP (Visual Basic)

Reply to this Message

Cindy M. - 03 Nov 2006 13:28 GMT

Hi TCook,

> For example, using a range object, one can dump the data to an array. Is
> there a way to do something similar with a range object and a datatable?

Not a .NET datatable, no. Excel (like most "traditional" Office apps) is
blissfully ignorent of all things .NET. Putting the range data into an
array, then that into the data table is probably your fastest choice if you
can't use a connection.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 17 2005)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or
reply in the newsgroup and not by e-mail :-)

Reply to this Message

How to Transfer an Excel Range to an ADO.Net DataSet or DataTable in VB.Net?

Free Magazines