delete aa12
insert into aa12(za0100,aa12id,zc9993,ak020c,ak020e,ak020d) SELECT AA01.ZA0100,100,1,结存数量,结存单价,结存金额 FROM OPENROWSET('MICROSOFT.JET.OLEDB.4.0','Excel 4.0;HDR=YES;DATABASE=d:/1月31日库存.xls',_09年1月31日库存$) As A Left Join AA01 On AA01.AK010D=A.存货编码 Where not IsNull(AA01.ZA0100,'')=''
delete aa12
insert into aa12(za0100,aa12id,zc9993,ak020c,ak020e,ak020d) SELECT AA01.ZA0100,100,1,结存数量,结存单价,结存金额 FROM OPENROWSET('MICROSOFT.JET.OLEDB.4.0','Excel 4.0;HDR=YES;DATABASE=d:/1月31日库存.xls',_08年$) As A Left Join AA01 On AA01.AK010D=A.存货编码 Where not IsNull(AA01.ZA0100,'')=''