Question

Access中如何用SQL插入记录

先看这段代码
Dim db1 As DAO.Database

Dim db2 As DAO.Database
Set db1 = CurrentDb
Set db2 = OpenDatabase("E:\a.accdb")
Dim rs1 As DAO.Recordset
Set rs1 = db1.OpenRecordset("Select a,b,c,e From tb1")
Dim rs2 As DAO.Recordset
Set rs2 = db2.OpenRecordset("tb2")

请问如何将rs1 insert into 到 rs2 中？？

Answer 1

Insert into 表(字段1,字段2,...) values(值1,值2,....)

insert into table1(A,B,C)
select A,B,C from t_table2
请采纳答案，支持我一下。

追问

不在同一个数据库