title: Sql query vba ADO
body: <p>The sheet name is DATA on excel, using F4 properties in VBA instead of sheet1 I have changed it to sData.</p>
  
  <p>My aql query is not returning any result.I need to extract a column from the Data Sheet of the same workbook in VBA.</p>
  
  <p>My code is : </p>
  
  <pre><code>Sql = "Select productNumber from [shtData$] where produvtDesc = "&amp;pDes&amp;" "
  'pDesc is a string variable that stores description.
  </code></pre>
  
  <p>Is this how we put the sheet name in sql query? I tried [Data$] as well but it doesn't work.</p>
  
  <p>Please help.</p>