How do you count number of records in Sql?

Hi:

I'm writing a VBA macro in xls to chart various records that I'm querying from MS SQL. One of the values that are most important for me to chart is the total number of records. The way I have the xls code, I can pull the data into xls and then count rows. However, sometimes the number of rows queried exceeds the 65K max rows in xls...and the program fails.

Could anyone suggest how I could just extract the number of records directly from sql, using a code that I can embed in my xls code?

Thanks in advance for your help!
-m

mason12345

Newbie Poster

6 posts since Feb 2007

Reputation Points: 10

Solved Threads: 0

5 Years Ago

Normaly I would use COUNT (), but i'm not sure about embeding SQL code in XLS!?

cheers

FreelanceHW

Newbie Poster

1 post since Feb 2007

Reputation Points: 10

Solved Threads: 0

This article has been dead for over three months

You