7,714
社区成员
发帖
与我相关
我的任务
分享
select * into bTab from [;pwd=123;database=D:\ITEM\DB.mdb.aTab].aTab
strSQL = "select * into " & vToName & " from " & sFromDB & "." & vFromName & " where 1>2"
Debug.Print strSQL
'select * into bTab from D:\ITEM\DA.mdb.aTab where 1>2
cnTo.Execute strSQL
[Quote=引用 4 楼 zhh0086 的回复:]
strSQL = "select * into " & vToName & " from " & sFromDB & "." & vFromName & " where 1>2"
Debug.Print strSQL
'select * into bTab from D:\ITEM\DB.mdb.aTab where 1>2
cnTo.Execute strSQL