Public conn As ADODB.Connection
Public rsbeng As ADODB.Recordset
Public cmd As ADODB.Command
Set conn = New ADODB.Connection
conn.Open "data source=beng;"
Set cmd = New ADODB.Command
Set cmd.ActiveConnection = conn
strsql = "select * from bengbiao"
cmd.CommandText = strsql
cmd.CommandType = adCmdText
Set rsbeng = cmd.Execute
Debug.Print rsbeng.RecordCount

请问　立即窗口为什么总显示-１呢？

默认游标类型是服务端游标，无法取得RecordCount.
可以使用客户端游标。

太感谢了

movefirst 一下