如何正确格式化这行代码以允许我在语句字符串中使用括号?
db。执行("SQL DB", "INSERT INTO abpcahirmis . DB . testdb (TEST) VALUES(1) ")
在VBA中,如果你调用sub,你不会在调用中添加括号,例如:
db.Execute "SQL DB", "INSERT INTO ABPCahirMIS.dbo.TESTDB (TEST) VALUES(1)"
像这样:
Dim dbs As DAO.Database, sql as String
Set dbs = "SQL DB"
sql = INSERT INTO ABPCahirMIS.dbo.TESTDB (TEST) VALUES(1)
dbs.Execute sql, dbFailOnError