Member Avatar for iamthwee

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/Work_with_Excel__VBNET_.asp
http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q316934

Any help would be appreciated.

  • 2 Contributors
  • 2 Replies
  • 84 Views
  • 2 Days Discussion Span
  • Latest Post Latest Post by Triss

Recommended Answers

All 2 Replies

Member Avatar for iamthwee

bump

Member Avatar for Triss

What you looking to do with the data?

I would read it into an array()?

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.