假定有数据库文件C:\data\A.Mdb(内有Table1), D:\data\B.Mdb 引用DAO 3.6 dim db as database set db = DBEngine.OpenDatabase("C:\data\A.Mdb") db.execute "select * into TableName in [D:\data\B.Mdb] from Table1" db.close set db = nothingD:\data\B.Mdb中的TableName可以随意起,当然也可以就是Table1。
如果我要将本地的access数据库的全部表都拷进远程的SQL SERVER里呢?
大哥,用 db.execute "select * into kkk in [d:\xx\xx.mdb] from mmm" 执行不了啊,为什么呢?
如果目标数据库有安全机制,就在目标数据库上打开db, 将IN字句放在源数据库一端(from子句): db.execute "select * into kkk from mmm in [d:\xx\xx.mdb]"
引用DAO 3.6
dim db as database
set db = DBEngine.OpenDatabase("C:\data\A.Mdb")
db.execute "select * into TableName in [D:\data\B.Mdb] from Table1"
db.close
set db = nothingD:\data\B.Mdb中的TableName可以随意起,当然也可以就是Table1。
db.execute "select * into kkk in [d:\xx\xx.mdb] from mmm"
执行不了啊,为什么呢?
db.execute "select * into kkk from mmm in [d:\xx\xx.mdb]"