| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.dotnet.framework.interop,microsoft.public.dotnet.languages.vb,microsoft.public.excel.programming
|
|||
|
|||
How to Transfer an Excel Range to an ADO.Net DataSet or DataTable in VB.Net?
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 :-) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| assign dataset to matching dataset | Excel Programming | |||
| Converting A Quarterly Dataset to Weekly Dataset | Excel Programming | |||
| Load a range of cells into a dataset with an opened workbook instance. | Excel Programming | |||
| Excel range into a vb.net dataset.... | Excel Programming | |||
| Excel into DataTable using OleDbDataAdapter | Excel Programming | |||
Threaded Mode
