rs2.open "Select * from '"&mtablename&"' where 监测时间 between '"&mstarttime&"' and '"&mendtime&"'","DSN=huanhao;" 我要查询的表名是个变量mtable,我怀疑是不是表名不能为变量啊,这样SQL怎么知道到那个表里面有”监测时间“呢这一列呢?我也是瞎猜的,想听你们的高见,反正就是通不过。
rs2.open "Select * from '"&mtablename&"' where 监测时间 between '"&mstarttime&"' and '"&mendtime&"'","DSN=huanhao;"
改称
rs2.open "Select * from '"&mtablename&"' where 监测时间 between #"&mstarttime&"# and #"&mendtime&"#","DSN=huanhao;"
BETWEEN应该是不能用“=”的:P
应该是这样吧,
rs2.open "Select * from '"&mtablename&"' where 监测时间 between '"&mstarttime&"' and '"&mendtime&"'" and "DSN=huanhao;"
如果还有错的话,请把错误帖出来我看看:)