I'm using the following code to retrieve data from uploaded Excel Spreadsheets, however the specs we got says "Worksheet named 'Sales' or something simular" .. The sample files we got have 3 names for the Same sheet, however they each start with 'Sale' .. Sales , Sale Totals, Sales Total ....

Code:
        Dim oledbconn As New OleDbConnection
        Dim oledbcmd As New OleDbCommand
        Dim strConn As String

        Try
             strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + strFilePath + ";Extended Properties=""Excel 8.0;IMEX=1;HDR=YES;"""
            oledbconn.ConnectionString = strConn
            oledbconn.Open()
            oledbcmd.CommandType = CommandType.Text

            oledbcmd.CommandText = "SELECT * FROM [Sales$]"
Now how can i query the Excel Speadsheet and get a list of Worksheet names, where i can the check and pass the correct name to the above code..

BTW. I need to do the same for another worksheet in the same file....