Urgent. Error in Fetching date field data from excel sheet

[cheguri]

Dear friend, I am trying to fetch data from excel sheet using ASP.NET with C#. I want to get data based on one date condition. All the rows in that date column are having date only. I don't know what's wrong. I have tried in many ways. I am getting the following error. [System.Data.OleDb.OleDbException] = {"Data type mismatch in criteria expression."} Since last day afternoon, I am struggling for this. I have written queries in all following possible ways. select * from [sheet1$] where [LoginDate]='21/04/10' select * from [sheet1$] where [LoginDate]='21/04/2010' select * from [sheet1$] where [LoginDate]='21-04-10' select * from [sheet1$] where [LoginDate]='21-04-2010' select * from [sheet1$] where [LoginDate]='21-Apr-10' select * from [sheet1$] where [LoginDate]='21-Apr-2010' select * from [sheet1$] where [LoginDate]='04/21/10' select * from [sheet1$] where [LoginDate]='04/21/2010' select * from [sheet1$] where [LoginDate]='04-21-10' select * from [sheet1$] where [LoginDate]='04-21-2010' select * from [sheet1$] where [LoginDate]='Apr-21-10' select * from [sheet1$] where [LoginDate]='Apr-21-2010' select * from [Sheet1$] where [LoginDate] = '"+DateTime.Parse("04-21-10").ToString()+"'" select * from [Sheet1$] where [LoginDate] = '"+DateTime.Parse("04-21-10")+"'" Still I am not getting. Can anyone, pls help me. It's very urgent. Regards, Dileep

[Sandeep Mewara]

There is a known issue with OleDb and dates! It expects dates in format: "yyyy-MM-dd hh:mm:ss" Try something like:

"SELECT * FROM [sheet1$] where [LoginDate]='" + myLoginDate.ToString("yyyy-MM-dd hh:mm:ss") + "'"

Read this thread for details and one more other option to use parameters: Data type mismatch in criteria expression[^]

[cheguri]

Thanks friends, I have got it in another way. select * from [sheet1$] where LoginDate=#21/04/10# It's working fine. Thanks everyone. Regards, Dileep.