Solved

Import Excel spreadsheet into vb.net data table (or whatever)

Posted on 2013-05-27
2
491 Views
Last Modified: 2013-05-28
Hi,

I need a snipped for importing an excel (2013) spreadsheet into a datatable, and I also need to make sure it's closed afterwards so I can edit it.

vb.net (vs2012)

Thanks
~j
0
Comment
Question by:prosit
2 Comments
 
LVL 45

Accepted Solution

by:
aikimark earned 500 total points
ID: 39201953
Have you used ADO to get data from a database?  If so, getting data from an Excel workbook will be similar.
You can specify a connection string to point to a workbook, just like you would point to an RDBMS (SQL Server, Oracle, DB2, or Access).
0
 
LVL 2

Author Closing Comment

by:prosit
ID: 39202245
I resolved it, thanks!
0

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Article by: jpaulino
XML Literals are a great way to handle XML files and the community doesn’t use it as much as it should.  An XML Literal is like a String (http://msdn.microsoft.com/en-us/library/system.string.aspx) Literal, only instead of starting and ending with w…
If you need to start windows update installation remotely or as a scheduled task you will find this very helpful.

856 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question