VB.NET Read an Excel File using OLEDB (Using SQL Where Clause).

See more:

VB

SQL

MS-Excel

I found a code for reading a Excel file using OLEDB.
Read Data from Excel using OLEDB in VB.NET 2005 [^]

Try
    Dim MyConnection As System.Data.OleDb.OleDbConnection
    Dim DtSet As System.Data.DataSet
    Dim MyCommand As System.Data.OleDb.OleDbDataAdapter
    MyConnection = New System.Data.OleDb.OleDbConnection _
    ("provider=Microsoft.Jet.OLEDB.4.0;"  _
    " Data Source='c:\testfile.xls'; " _
     "Extended Properties=Excel 8.0;")
    MyCommand = New System.Data.OleDb.OleDbDataAdapter _
        ("select * from [Sheet1$]", MyConnection)
    MyCommand.TableMappings.Add("Table", "TestTable")
    DtSet = New System.Data.DataSet
    MyCommand.Fill(DtSet)
    DataGridView1.DataSource = DtSet.Tables(0)
    MyConnection.Close()
Catch ex As Exception
    MsgBox(ex.ToString)
End Try

The above code displays all data from Excel File. My question is how to put the Where Statement in the sql command. I just try using the header but it doesn't work.