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.