Reading Excel data conditionally using ADO
Posted on 2004-04-13
I m tring to read data from an excel sheet conditionally. for eg i want to read all fields from the excel sheet where the date is '4/4/2004' or may be greater than or lesser than that date . I am unable to do so.
I m using ADO.
the query i m using is "select * from [ESTROCIT$] where oc_no=38 and oc_dt = '4/12/2004'"
but the error i get is "Microsoft JET Database Engine (0x80040E07)
Data type mismatch in criteria expression."
could ne one give me ne pointers?