SQL查询数据如何用变量替代表名？
ku = "dbo. MM_RAWENTRY_DT"
Sql = "select * from( '" & ku & "' )where( RAWENTRY_ID between '" & DTPicker1.Value & "' and '" & DTPicker2.Value & "')"
Rs.Open Sql, CN, 1, 3
这条语句有什么错误吗，总是返回空的结果。而下面这样就可以得到数据。是为什么？
Sql = "select * from dbo. MM_RAWENTRY_DT where( RAWENTRY_ID between '" & DTPicker1.Value & "' and '" & DTPicker2.Value & "')"
Rs.Open Sql, CN, 1, 3
[解决办法]
表名两边不要单引号.
