Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Counting records
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Counting records
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" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Counting records f(x) two columns | Excel Discussion (Misc queries) | |||
counting records | Excel Worksheet Functions | |||
Counting unique records | Excel Worksheet Functions | |||
Counting records within a month | New Users to Excel | |||
Counting Unique Records | Excel Programming |