Guys, I've been working this for almost 3 hours but still I can't find the solution, I'm encountering an error "Could not find installable ISAM". I actually want to query an excel file with the use of oledb connection and "WHERE Clause". Is it possible? Here's my code. Hope you help me here, I really need this, I'm working my Project for almost 3 months and I want to finish this.
dt = New DataTable
dtempcount = New DataTable
excelconnection = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data Source='" & txtfilename.Text & " '; " & "Extended Properties=Excel 8.0; HDR=YES;")
exceladapter = New OleDbDataAdapter("select * from [sheet1$] where EMP_ID='Employee ID'", excelconnection)
exceladapter.Fill(dt)
dg.DataSource = dt