Member Avatar for mason12345
mason12345 0 Newbie Poster

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 total count of records directly from sql? If this is not the correct forum, please let me know.

Thanks in advance for your help!
-m

  • 1 Contributor
  • 0 Replies
  • 63 Views
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.