insert into join jian.DSCSYS.dbo.COPMG (G001,MG002,MG003,MG004,MG005,MG006 ) select a.G001,a.G002,a.G003,a.G004,a.G005,a.G006 from openrowset('microsoft.jet.oledb.4.0','Excel 8.0;HDR=yes; Database=C:\Documents and Settings\hou\桌面\xujing.xls;', 'select MG001,MG002,MG003,MG004,MG005,MG006 from [Sheet1$]') a where not exists (select 1 from jian.DSCSYS.dbo.COPMG b where a.MG001=b.MG001 AND a.MG002=b.MG002 and a.MG003=b.MG003 )
select a.G001,a.G002,a.G003,a.G004,a.G005,a.G006
from openrowset('microsoft.jet.oledb.4.0','Excel 8.0;HDR=yes;
Database=C:\Documents and Settings\hou\桌面\xujing.xls;',
'select MG001,MG002,MG003,MG004,MG005,MG006 from [Sheet1$]') a
where not exists (select 1 from jian.DSCSYS.dbo.COPMG b where
a.MG001=b.MG001
AND a.MG002=b.MG002
and a.MG003=b.MG003
)