1、insert into table3(...) select ... from table1/table2 2、VBA里面可以使用ADO来访问数据库,给你一个例子: Public cnn As New ADODB.Connection Public rst As New ADODB.Recordset Public sqlstr As String Set cnn = New Connection cnn.Open "provider=……" sqlstr = "" '你的SQL语句 Set rst = New Recordset rst.CursorLocation = adUseClient rst.Open sqlstr, cnn, adOpenStatic, adLockOptimistic rst.Close cnn.Close
语句是什么?
2、VBA里面可以使用ADO来访问数据库,给你一个例子:
Public cnn As New ADODB.Connection
Public rst As New ADODB.Recordset
Public sqlstr As String
Set cnn = New Connection
cnn.Open "provider=……"
sqlstr = "" '你的SQL语句
Set rst = New Recordset
rst.CursorLocation = adUseClient
rst.Open sqlstr, cnn, adOpenStatic, adLockOptimistic
rst.Close
cnn.Close