Reading from an excel file

•

What is DaniWeb IT Discussion Community?

You're currently browsing the VB.NET section within the Software Development category of DaniWeb, a massive community of 456,580 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 3,610 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.

Join our community!

Please support our VB.NET advertiser: Programming Forums

Thread Tools Display Modes

Views: 2061 | Replies: 2

•

Join Date: Aug 2005

Posts: 4,832

Reputation: iamthwee is a glorious beacon of light

Rep Power: 17

Solved Threads: 324

iamthwee

Offline

Industrious Poster

Reading from an excel file

Nov 3rd, 2007

Ok, I'm using Microsoft excel version 2002. And VB 2005 express.

I have imported the com library.

Project > Add reference > com tab > microsoft 10.0 object library.

Now how would I go about reading data from the spreadsheet? Surely there must be something easier than using oledb?
http://www.codeproject.com/useritems...el__VBNET_.asp
http://support.microsoft.com/default...;EN-US;Q316934

Any help would be appreciated.

Last edited by iamthwee : Nov 3rd, 2007 at 8:33 am.

... the hat of 'is this a cat in a hat?'