title: How to connect to Excel named range in ADODB SQL query
body: <p>I need to move data from Excel sheet to database. To do this, I create ADODB Connection and I am able to execute such an SQL query:
  <code>INSERT INTO myTable SELECT * FROM [Excel 12.0 Macro;HDR=Yes;Database=C:\MyPath\MyFile.xlsb].[Shee1$A1:C100]</code></p>
  
  <p>My problem is that the range cannot point further than 255 columns, i.e. column IU. I want to try using named range instead, but I cannot find suitable notation. All examples I found connect directly to the workbook, and use either <code>SELECT * FROM [Sheet1$]</code> reference, or <code>SELECT * FROM myRange</code> as an example of named range. I tried things like </p>
  
  <pre><code>[Excel 12.0 Macro;HDR=Yes;Database=C:\MyPath\MyFile.xlsb].[myRange]
  [Excel 12.0 Macro;HDR=Yes;Database=C:\MyPath\MyFile.xlsb].[myRange$]
  [Excel 12.0 Macro;HDR=Yes;Database=C:\MyPath\MyFile.xlsb].myRange
  [Excel 12.0 Macro;HDR=Yes;Database=C:\MyPath\MyFile.xlsb;Name=myRange]
  </code></pre>
  
  <p>, but without success. </p>
  
  <p>What is the proper way to use named range here? Would it even help working around column number limitation?</p>
  
  <p>I expected <code>[Excel 12.0 Macro;HDR=Yes;Database=C:\MyPath\MyFile.xlsb].[myRange]</code> to work, but it throws the following error: 'The Microsoft Access database engine could not find the object 'myRange'. Make sure the object exists (...)'</p>
  
  <p>I can work it around by copying data from source sheet to temporary one, and have it within 255 column limit, but it would be great do it right way.</p>