Dim cn As ADODB.Connection Dim Sql As String Set cn = New ADODB.Connection cn.Open "连接数据库A的字符串"1.如果数据库B中表已经存在 sql = "INSERT INTO [C:\B.mdb].[TableName] SELECT * FROM [TableName]" cn.Execute Sql 2.如果数据库B中表不存在 Sql = "SELECT * INTO [C:\B.mdb].[TableName] FROM [TableName]" cn.Execute Sql
不行啊,出错啊,不可识别数据库,怎么回事啊! insert into [d:\ratio.mdb].[ratio] select * from [ratio] 这样句SQL语句没错吧!!!数据库和表都是存在的啊!
晕哦!insert into [d:\ratio.mdb].ratio select * from ratio
Dim Sql As String
Set cn = New ADODB.Connection
cn.Open "连接数据库A的字符串"1.如果数据库B中表已经存在
sql = "INSERT INTO [C:\B.mdb].[TableName] SELECT * FROM [TableName]"
cn.Execute Sql
2.如果数据库B中表不存在
Sql = "SELECT * INTO [C:\B.mdb].[TableName] FROM [TableName]"
cn.Execute Sql
insert into [d:\ratio.mdb].[ratio] select * from [ratio]
这样句SQL语句没错吧!!!数据库和表都是存在的啊!