odbc select excel

Yes I have a select query to select the sheet name, I was wondering is there anyway to select a sheet name dynamically, so the sheet name can be what ever but the select statement will still select that sheet name.
Dim MyConnection As System.Data.OleDb.OleDbConnection
        Dim sqlStr As String = "SELECT * FROM [030120080704$]", extendedString As String
        MyConnection = New System.Data.OleDb.OleDbConnection( _
              "provider=Microsoft.Jet.OLEDB.4.0; " & _
              "data source=C:\Excel\Grocery7-04-08.xls; " & _

Open in new window

Seven priceFull StackAsked:
Who is Participating?
Jorge PaulinoConnect With a Mentor IT Pro/DeveloperCommented:
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.