请再帮我看看，Excel更新到Access的

[tatty_bad]

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.MDB;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

数据库是Access的。

是在VBA里面执行的，提示操作符丢失。

[tatty_bad]

55555,还没有人帮我看看

[tatty_bad]

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

上面的文件名写错了。
应该是dd.xls