高分悬赏,解决问题立即结贴。
Update a set a.a17 = b.a17,a.a18 = b.a18,a.a19 = b.a19,a.a20 = b.a20 from [TableB] a inner join [Excel 8.0;DATABASE=C:\DD.xls;HDR=YES;IMEX=1].[Sheet1$A7:BC100] b on a.a1 = b.a1 and a.a4 = b.a4 and a.a7 = b.a7 and a.a11 = b.a11 and b.AID = 1
把Excel中从第7行开始到最后一行的数据,更新到Access表里面去。
Update [TableB] a inner join [Excel 8.0;DATABASE=" & ThisWorkbook.FullName & ";HDR=YES;IMEX=1].[" & WorkBookName & "$A7:BC" & ynum & "] b on a.a1 = b.a1 and a.a4 = b.a4 and a.a7 = b.a7 and a.a11 = b.a11 and b.AID = " & CustId & " set a.a17 = b.a17,a.a18 = b.a18,a.a19 = b.a19,a.a20 = b.a20
上面这句,我曾经在前两天执行成功过。但是今天不知道为什么,提示我:
运行时错误:-2147214900(80040e14)
不支持连接表达式
请高手帮我把这句话修改一下。
成功了立即结贴。