Member Avatar for mason12345

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

  • 2 Contributors
  • 1 Reply
  • 74 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by FreelanceHW
Member Avatar for FreelanceHW

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

cheers

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.