Dim rs As New ADODB.Recordset
Set cnn = New ADODB.Connection
cnn.Open "rovider=SQLOLEDB;Data Source=*.*.*.*;UID=saWD=******;initial catalog=SQL"
sql = "INSERT INTO Tb_表A_temp ( 表AID, 表BID, FZID, FHQTY1, FHDPT, FH ) SELECT 表AID, 表BID, FZID, Sum(FHQTY) AS FHQTY1,FHDPT,FH FROM Tb_表A WHERE 表AID&表BID&FZID&FHQTY In(select 表AID&表BID&FZID&FHQTY as UnF from Tb_表A group by 表AID&表BID&FZID&FHQTY having count(*)=1) GROUP BY 表AID, 表BID, FZID, FHQTY,FHDPT,FH"