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
"Paul Clement" <Us***********************@swspectrum.comwrote in message
news:5i********************************@4ax.com...
On Thu, 2 Nov 2006 00:29:45 -0500, "TCook" <ge**********@yahoo.comwrote:
¤ 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)