Author: toma12 | Posted on: 9/28/2007 9:16:58 AM | Views : 284

I'm starting to mess around with importing Excel sheets into gridviews. Thanks to some research in this forum, I have almost everything I need. The problem I have is all the examples require the system to already know the sheet name or have a named range defined in Excel:

OleDbCommand objCmdSelect = new OleDbCommand("SELECT * FROM myRange1", objConn);

Is there a way to just get the first worksheet of information regardless of name? Oh, one other twist, the sheet may already be named, so I cannot assume it is the default name.

Any help is appreciated!
...

Go to the complete details ...