sql="select * from [200409] where 采样时间 between '2004-7-6' and '2005-1-6'
union all select * from [200410] where 采样时间 between '2004-7-6' and '2005-1-6'
union all select * from [200411] where 采样时间 between '2004-7-6' and '2005-1-6'
union all select * from [200412] where 采样时间 between '2004-7-6' and '2005-1-6'
union all select * from 仪表数据 where 采样时间 between '2004-7-6' and '2005-1-6'
"
rs.open sql
rs=nothing
union all select * from [200410] where 采样时间 between '2004-7-6' and '2005-1-6'
union all select * from [200411] where 采样时间 between '2004-7-6' and '2005-1-6'
union all select * from [200412] where 采样时间 between '2004-7-6' and '2005-1-6'
union all select * from 仪表数据 where 采样时间 between '2004-7-6' and '2005-1-6'
"
rs.open sql
rs=nothing