1
delete from 表2
insert into 表2 select * from 表12 如果表2中有值唯一的字段Field1
insert into 表2 select * from 表1 where field1 not in(select field1 from 表2)
delete from 表2
insert into 表2 select * from 表12 如果表2中有值唯一的字段Field1
insert into 表2 select * from 表1 where field1 not in(select field1 from 表2)
Dim b As Database
Dim s As New ADODB.Recordset
a.ConnectionString = "driver={sql server};server=sds;uid=sa;pwd=abc;database=carmsg"
a.Open
Set s = a.Execute("select * from att_color")
Set b = OpenDatabase("c:\carmsg.mdb")
b.Execute ("delete from att_color")
b.Execute ("insert into att_color select * from s ") ''''出错我该怎么改?
2.在MDB里建一个链接表,把SQL SERVER里的数据导过来,然后再INSERT.