Query parameters in an external connection to sql server
I want to do exactly
this:http://dailydoseofexcel.com/archives/2004/12/13/parameters-in-excel-external-data-queries/
but I want to do it in Excel 2010 and also I am querying SQL Server
instead of MS Access. Is it possible?
To elaborate on what I want from that link exactly is to have query
parameters that reference cells in the worksheet. At present I'm using VBA
and a cell change trigger event. Is there a simpler way?
No comments:
Post a Comment