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

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

cheers