我有一个excel,有一个SHeet 叫OPEN REQUESTS,其中有一列叫Date,格式为:
2002-10-24 05:12:01 PM
2002-11-19 06:44:25 PM
如何根据日期查询?
select * from [OPEN REQUESTS$] where ...?
请问一下后面怎么写?
2002-10-24 05:12:01 PM
2002-11-19 06:44:25 PM
如何根据日期查询?
select * from [OPEN REQUESTS$] where ...?
请问一下后面怎么写?
测试通过
Dim s2 As Date
s1 = "2004-06-07"
s2 = "2004-06-08"
Dim strsql As String
strsql = "SELECT * FROM [sheet1$] where date1>=# " & s1 & " # and date1<=# " & s2 & " #"
rs.Open strsql, sconn