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 ...