I have an application that loads a dataset from an Excel document. For the dataadpater I use
I would like to get the actual value of Sheet1 before I pull the dataset. Is their a way to get the value by opening the document?(I know how to open the document I just cant find how to return the sheet name) Thanks.
Matt McCartney
Code:
Dim odaExcel As New OleDbDataAdapter("SELECT * FROM [Sheet1$]", conn)
Matt McCartney