本帖最后由 xiahuaxian 于 2016-1-18 08:18 编辑
前面两段的最后,all后面加上空格试一试.SQL1 = "select 设备注册代码 as 1,[使用单位名称(表1)] as 2,[有效期(表1)] as 3,null as 4,null as 5 from [数据表1$] union all "
SQL2 = "select 注册代码 as 1,单位 as 2,null as 3,[有效期(表2)] as 4,[联系人(表2)] as 5 from [数据表2$] union all "
SQL3 = "select 注册代码 as 1,单位 as 2,null as 3,[有效期(表2)] as 4,[联系人(表2)] as 5 from [数据表2$] union all select t1.设备注册代码 as 1,t1.[使用单位名称(表1)] as 2,t1.[有效期(表1)] as 3,t2.[有效期(表2)] as 4,t2.[联系人(表2)] as 5 from [数据表1$] t1,[数据表2$] t2 where t1.设备注册代码=t2.注册代码"
SQL = SQL1 & SQL2 & SQL3
我试一下,加空格能运行,不加就是发生你说的错误.
|