-- 请教一个vba数据库的写法问题
Sub cs()
set adoConn=createobject("Adodb.connection")
adoConn.open "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=D:\\Weisoft Stock\\test.accdb"
strSqlread="select stockdate from RB00 where vclose =2193 "
Set rstTmp=CreateObject("ADODB.RecordSet")
rstTmp.open strSqlread,adoConn
aa=rstTmp("stockdate ")
application.msgout " aa:" & aa
End Sub
为什么上面通过vclose字段找stockdate字段是对的,下面通过stockdate字段找vclose字段却报错?该怎么写?另外,请问如何找最后一行的stockdate值?
Sub cs()
set adoConn=createobject("Adodb.connection")
adoConn.open "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=D:\\Weisoft Stock\\test.accdb"
VV=cdate("2016/4/1")
strSqlread="select vclose from RB00 where stockdate=" & vv
Set rstTmp=CreateObject("ADODB.RecordSet")
rstTmp.open strSqlread,adoConn
aa=rstTmp("vclose")
application.msgout " aa:" & aa
End Sub