vba将select的值直接赋给变量

strSql = ""
strSql = strSql & " select max(number)  from dbo.#DATA" & vbCrLf
rss.Open strSql, cnn
  numb = rss.Fields(0)
rss.Close

原文地址:https://www.cnblogs.com/zigewb/p/2900645.html