表结构一样的话: insert Into table2 select * from table1 where table1.field1 not in (select field1 from table2) update table2 set field2=b.field2,field3=b.field3... from table1 b ,table2 a where a.field1=b.field1如果表结构不同的话用类似的方法把字段写上去。Access和sqlserver也可以, 把"table1"改成openrowset('Microsoft.Jet.OLEDB.4.0', 'x:\Access数据库.mdb';'admin用户名';'密码,为空不填',table1)
~~~~~~~~~~~~~~~~~~~~~~~~`
insert Into table2 select * from table1 where table1.field1 not in (select field1 from table2)
update table2 set field2=b.field2,field3=b.field3... from table1 b ,table2 a where
a.field1=b.field1如果表结构不同的话用类似的方法把字段写上去。Access和sqlserver也可以,
把"table1"改成openrowset('Microsoft.Jet.OLEDB.4.0',
'x:\Access数据库.mdb';'admin用户名';'密码,为空不填',table1)