Counting records

  • Thread starter Thread starter Slim Jim
  • Start date Start date
S

Slim Jim

Hi there

I am connecting to a SQL Server stored procedure in Excel
VBA.

However, I am having difficulty COUNTING the number of
records returned from that Stored Procedure.

I have this code...

Dim conDB As New ADODB.Connection
Dim rstSP As New ADODB.Recordset
Dim strConnect As String

strConnect = "driver={sql server};server=
(local);database=mydb;uid=;pwd=;"


With conDB
 
Where is the rest of the code? If you are assigning the return value of the
sp call to a rs, then just get the recordcount property of the rs.
 
Back
Top