excel VBA 如何修改数据库代码为中文名？

Question

这段代码StrSQL = "Select sum(合计) From [sheet1$A:O] Where 类型='" & [A4] & "' And 收支日期 Between #" & [B2] & "# And #" & [B3] & "#"运行没有什么问题
但改成StrSQL = "Select sum(合计) From [sheet("数据")$A:O] Where 类型='" & [A4] & "' And 收支日期 Between #" & [B2] & "# And #" & [B3] & "#"就运行不了，请问怎么改工作表名称才是正确的？

Answer 1

数据用单引号