Lee21 0 Light Poster

Guys,please help me. I want to filter data from man excel file as my data source is it possible to use "WHERE Clause"?Here's my code

dt = New DataTable
            dtempcount = New DataTable
excelconnection = New OleDbConnection("provider=Microsoft.Jet.OLEDB.4.0; data source='" & txtfilename.Text & " '; " & "Extended Properties=Excel 8.0;")

 dtempfil = New DataTable
            sda = New SqlDataAdapter("SELECT EMPL_ID FROM KEMPMASTER WHERE HEAD='" & modGlobalvar.name & "'", sqlcon)
            sda.Fill(dtempfil)
            If dtempfil.Rows.Count <> 0 Then
                bilang2 = 0
                While bilang2 <> dtempfil.Rows.Count
             
exceladapter2 = New OleDbDataAdapter("SELECT * FROM [sheet1$] WHERE EMPL_ID='" & dtempfil.Rows(bilang2).Item(0) & "'", excelconnection)
exceladapter2.Fill(dt)
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.