Set value of Excel cell to the result of a query [modified]

[anthasaurus]

Hi all, I am looking at ways to automate the process of getting data from SQL Server 2008 into an Excel (2007) spreadsheet. I would like to set the value of a cell in the spreadsheet to the result of a SELECT COUNT query. Is this possible? Regards, Anthony

modified on Thursday, August 26, 2010 5:21 AM

[Lost User]

anthasaurus wrote:

Is this possible?

Yup. Start here[^] :)

I are Troll :suss: