title: How do I use a parameter in an Excel external data request?
body: <p>I can already use Excel (2007) to import data from SQL Server 2005. I add a data connection and I enter a custom SQL query that retrieves my desired data. Cool.</p>
  
  <p>But what I'd like to add is the ability to parameterize that query based on a value found in a known cell on the spreadsheet.</p>
  
  <p>My query would go from</p>
  
  <pre>SELECT * FROM dbo.MyDataTable WHERE Col1 = 'apples'</pre>
  
  <p>to something like</p>
  
  <pre>SELECT * FROM dbo.MyDataTable WHERE Col1 = 'Cell("B2")'</pre>
  
  <p>Is this possible? If so, how?</p>