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?

Any help would be appreciated.