title: How to get column names when using OPENROWSET?
body: <p>I'm working on transforming some data that is contained within an EXCEL file, and I'm using OPENROWSET to do this. I can get the data with a <code>select *</code> type syntax, but I'm not getting any column names back in the results.
  In this case, the result is one simple value that I'd like to use or place in a temp table or variable.</p>
  
  <p>However, this value comes back as NULL in the last select statement. What am I missing here? Is the SQL syntax in the OLEDB call correct (it seems to be limited)?</p>
  
  <pre><code>declare @catalog_ID nvarchar(100);
  set @catalog_ID = (select * FROM OPENROWSET('Microsoft.ACE.OLEDB.12.0','Excel 12.0;HDR=yes;Database=D:\[my-worksheet].xlsx','SELECT * FROM [ru_RU$a3:b3]') )
  select @catalog_ID;
  </code></pre>