Hi all,
Hoping someone can assist with a sample to return a single result from SQL without using a listobject.
e.g. "Select Count (*) from Table1" should give me a single number like 1234. I don't want a listobject, I just want the number to drop into a single cell in Excel.
The objective is perhaps also stated differently as to get rid of the list object header/filter row and just return the data. Unfortunately all of the samples I've come across all use listobject which has the header/filter row.
Thanks!
Hoping someone can assist with a sample to return a single result from SQL without using a listobject.
e.g. "Select Count (*) from Table1" should give me a single number like 1234. I don't want a listobject, I just want the number to drop into a single cell in Excel.
The objective is perhaps also stated differently as to get rid of the list object header/filter row and just return the data. Unfortunately all of the samples I've come across all use listobject which has the header/filter row.
Thanks!