title: Reading xlsx saved as xls with LinqToExcel
body: <p>Look at this post: <a href="https://stackoverflow.com/questions/1139390/excel-external-table-is-not-in-the-expected-format">Excel &quot;External table is not in the expected format.&quot;</a> </p>
  
  <p>I have the same problem depicted in that post but I'm using LinqtoExcel to read the file instead of plain queries. </p>
  
  <p>What would be the LinqToExcel equivalent for setting the connection string as the answer to that post suggests?</p>
  
  <p><strong>Here is the code I'm using:</strong></p>
  
  <pre><code>var excelOM = new ExcelQueryFactory(pPathArchivoOM);
  var despachosClient = from c in excelOM.Worksheet&lt;RegistroDespachoOM&gt;("Tabla_1")
                           where c.DESTINAT.Contains("SOMETEXT")
                           select c;
  //Identificar los despachos asociados a números de documento sin datos aún.
  foreach (RegistroDespachoOM despacho in despachosClient)
  { ...
  </code></pre>
  
  <p>And my problem is: "External table is not in the expected format" in the foreach start.</p>
  
  <p><strong>EDIT (my problem is solved but the question remains unanswered):</strong> I'm using EPPlus instead of LinqToExcel for this task and all is working OK now.</p>