title: External table is not in the expected format - But works if I open and close the file
body: <p>I am trying to read and excel file but I get the "External table is not in the expected format" error.</p>
  
  <p>If I open and close the xls file and rerun it works.  I'm sure this is problem with the customer's data, but because it worked before a recent patch, they are unwilling to look into the issue.</p>
  
  <p>I have tried these connection strings.  They work only after I open and close the file myself.
  <code>
  "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" &amp; xlsPath &amp; ";Extended Properties=""Excel 12.0"""
  "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" &amp; xlsPath &amp; ";Extended Properties=""Excel 12.0 Xml;HDR=YES;IMEX=1"""
  "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" &amp; xlsPath &amp; ";Extended Properties=""Excel 8.0;HDR=YES;"""
  </code>
  Has anyone else run into this issue?</p>
  
  <p>Thanks</p>