Retrieving Excel Data with VB

[charlesr13]

Hi all

I am having problems with some programming. I'm using Visual Basic Express 2005, Access 2003 and an OleDB Connection.
I can query the database and successfully fill a datagridview.
I can query the database and fill a textbox with data from a field from the database.
My next step is to be able to convert excel documents to access databases, I assume this will be a big task?
I am looking for any useful information, links, nudge in a direction.

It is for a school project but the way this seems to work is I can use any code I want provided I state my source. That being said I am enjoying writing it myself so tutotials would also be great

Cheers

Edit: Complete rewrite ...