delete from userInfoOfAtt
-------------------------
insert into userInfoOfAtt
select userid,badgenumber,name,defaultdeptid
FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0',
'\\191.1.1.120\ZKSoftware\Att16\att2000.mdb';'admin';'',userinfo)
-------------------------
insert into userInfoOfAtt
select userid,badgenumber,name,defaultdeptid
FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0',
'\\191.1.1.120\ZKSoftware\Att16\att2000.mdb';'admin';'',userinfo)
确保没有人以独占方式打开它,你再打就不会出错了!
此问题常见于windows xp操作系统