title: How to reference a table on an Excel worksheet using OPENROWSET?
body: <p>Is there any way to reference a <em>table</em> on an Excel worksheet using OPENROWSET?</p>
  
  <p>Referencing a whole sheet works:</p>
  
  <pre><code>SELECT * FROM OPENROWSET('Microsoft.ACE.OLEDB.12.0', 'Excel 
  12.0;Database=D:\Temp\test.xlsm;IMEX=1;HDR=Yes','select * from [Sheet1$]')
  </code></pre>
  
  <p>Referencing a range on sheet works too:</p>
  
  <pre><code>SELECT * FROM OPENROWSET('Microsoft.ACE.OLEDB.12.0', 'Excel 
  12.0;Database=D:\Temp\test.xlsm;IMEX=1;HDR=No','select * from [Sheet1$A1:Z100]')
  </code></pre>
  
  <p><em>This is not working... trying to reference Table1</em></p>
  
  <pre><code>SELECT * FROM OPENROWSET('Microsoft.ACE.OLEDB.12.0', 'Excel 
  12.0;Database=D:\Temp\test.xlsm;IMEX=1;HDR=No','select * from [Sheet1$Table1]')
  </code></pre>
  
  <p>NOTE:
  If this is not possible, then can anybody suggest a different method, maybe using C#/VB.Net to achieve this?</p>