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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Slim Jim 5
Like operator in SQL with Excel Driver 3
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
VBA Excel data to SQL Sever table 1
passing multiple parameters to a Stored Procedure 2
Timeout Expired 3
Runtime error 91 when connecting to SQL Server 2000 1
Connection String to SQL Server in VBA 5

Back
Top