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.