myName = GetmyName() ' gets the name of sheet starting with 'Data' For e.g. sheet name can be 'Data-20150205'
myName = "[" & myName & "$]"
rs.Open " SELECT [State] FROM myName WHERE (([Country]='United States') AND ([Capital]='Boston')) ", cn, adOpenKeyset, adLockReadOnly
myName = GetmyName() ' gets the name of sheet s
阅读背景：
SQL查询无法识别工作表名称并引发错误
来源：互联网
分享到：
