VB.NET reference file (EXCEL)

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

depends on what you need

this is ADO.NET

this is using Interop

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

share what you know, learn what you don't
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.
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.