更新
update computer set computer.ppxh=Sheet1$.型号
from computer,Sheet1$
where computer.cname=Sheet1$.电脑名
插入
insertinto tmp_callin(TOperaName) select ITEMNAME from YW_WORKRECORDTYPE
更新
update computer set computer.ppxh=Sheet1$.型号
from computer,Sheet1$
where computer.cname=Sheet1$.电脑名
插入
insertinto tmp_callin(TOperaName) select ITEMNAME from YW_WORKRECORDTYPE
转载于:https://www.cnblogs.com/luqingsong/archive/2011/12/09/2282340.html