title: SQL Query to Oracle Database with cells as parameters
body: <p>I'm trying to query an Oracle DB from excel. I need to pass values from cells (dates etc.) into the query, this is where I'm having trouble. Say in the below simple example the date is in cell A2 </p>
  
  <pre><code>SELECT * 
  FROM ORACLE_DB 
  WHERE DATE = A2
  </code></pre>
  
  <p>I've tried following the instructions on <a href="https://support.office.com/en-us/article/customize-a-parameter-query-addf7cb7-ddf0-442f-a60c-cd7280e201bd" rel="nofollow noreferrer">https://support.office.com/en-us/article/customize-a-parameter-query-addf7cb7-ddf0-442f-a60c-cd7280e201bd</a> but it won't work as certain buttons are grey for me such as 'parameters' in the 'definition' tab and seemingly no amount of messing around with it will work.</p>
  
  <p>Other proposed solutions don't work such as changing A2 in the above example to :</p>
  
  <pre><code>Worksheets("Sheet").Range("A2").Value
  </code></pre>
  
  <p>I haven't yet tried writing something in VBA, but surely there's an easier way to do it? Any help on this would be greatly appreciated!</p>