write some vba code, something likeDim db As Database
Dim strSQL As String
Set db = CurrentDb()
strSQL = "SELECT oldtable.* " _
& "INTO newtable IN ""C:\whateverPath\newdbfile.MDB"" _
& "FROM oldtable"
db.Execute strSQL, dbFailOnError
'....
Set db = Nothing
Dim strSQL As String
Set db = CurrentDb()
strSQL = "SELECT oldtable.* " _
& "INTO newtable IN ""C:\whateverPath\newdbfile.MDB"" _
& "FROM oldtable"
db.Execute strSQL, dbFailOnError
'....
Set db = Nothing
用 Access打开源数据库(如A.mdb),选中其中要复制的表,右键弹出菜单进行“复制”操作,而后用 Access打开目标数据库(如B.mdb),右键弹出菜单进行“粘贴”操作,这是会出来选择对话框,选择“粘贴数据和结构”,而后再这个新生成的表命名为和源数据库中的源表一样的表名。结束