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)