Counting records

[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

[JM]

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.



"Slim Jim" <[email protected]> wrote in message
news:[email protected]...
> 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
>