VB.NET reference file (EXCEL)

Where is the reference file located in order to read an excel file in VB.NET?
SynapcoCanadaAsked:
Who is Participating?
 
bruintjeConnect With a Mentor Commented:
Hi SynapcoCanada,
----------

depends on what you need

this is ADO.NET
http://www.experts-exchange.com/Q_20972338.html

this is using Interop
http://uk.builder.com/0,39026540,39285438,00.htm

if you use COM interop as in the last sample you need to reference Excel in the COM Tab of your project references

----------
bruintje
share what you know, learn what you don't
0
 
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
Microsoft Excel {Your Version} Object Library

C:\Program Files\Microsoft Office\Office\EXCEL{Your Version}.olb

Office may be Office11 or Office12, depending on your version

9 = Excel 2000
10 = Excel XP/2002
11 = Excel 2003

Hope this helps.
-Jim
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.