1,216
社区成员
发帖
与我相关
我的任务
分享
Private Sub Command1_Click()
Dim db1 As Database
Dim db2 As Database
Set db1 = OpenDatabase("d:\车间库.mdb")
db1.Execute ("INSERT INTO [;database=d:\行政库.mdb;].[员工]([姓名],[性别],[生日]) SELECT [姓名],[性别],[生日] FROM [员工]")
end sub
Private Sub Command1_Click()
Dim db1 As Database
Dim db2 As Database
Set db1 = OpenDatabase(App.Path & "\a.mdb")
db1.Execute ("INSERT INTO [;database=" & App.Path & "\b.mdb;].[员工]([姓名],[性别],[生日]) SELECT [姓名],[性别],[生日] FROM [员工]")
End Sub
DB_db2.Execute ("INSERT INTO [" & DB_db2 & "].员工(姓名,性别,生日) SELECT 姓名,性别,生日 FROM 员工")
Private Sub Command1_Click()
Dim cn As ADODB.Connection
Set cn = New ADODB.Connection
cn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\b.mdb;Jet OLEDB:Database Password=b"
cn.Execute "Select * Into [tbla] From [;database=" & App.Path & "\a.mdb;pwd=a].tbla"
cn.Close
Set cn = Nothing
End Sub