title: Excel parameters from SQL Query from ODBC "Error - No Value given for one or more required parameters when using question mark `WHERE XXX = ?`
body: <p>I have an Excel file with an <code>SQLOLEDB</code> connection to a MS SQL server,</p>
  
  <p>When I do this with an Oracle link  I can simply put <code>WHERE XXX = ?</code> in my query to prompt for values in Excel, however doing it with MSSQL I am getting the following error:</p>
  
  <blockquote>
    <p>No Value given for one or more required parameters</p>
  </blockquote>
  
  <p>When trying to parameterise a basic excel query from a value to <code>?</code></p>
  
  <p>If i use values like this I get results:</p>
  
  <pre><code>SELECT * 
  FROM srv.stats
  WHERE srv.stats.[year] = '2016'
  AND srv.stats.[quarter] = '1'
  </code></pre>
  
  <p>When I add in the parameter <code>?</code> I get the above error.</p>
  
  <pre><code>SELECT * 
  FROM srv.stats
  WHERE srv.stats.[year] = ?
  AND srv.stats.[quarter] = ?
  </code></pre>
  
  <p>I want to be able to do this without using VB.</p>