title: "Could not find installable ISAM" - ".xlsx" reading no errors but reading "xls" file Get that error on windows 7 32bit
body: <pre><code> OleDbConnection excelConnection=null;
              try
              {
                  if (Path.GetExtension(excelFileName).Equals(".xls"))
                  {
                      string conStr = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + excelFileName + ";Extended Properties=" + "\"Excel 8.0 Xml;HDR=YES;IMEX=1;\"";
                      excelConnection = new OleDbConnection(conStr);
                  }
                  else
                  {
                      string conStr = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + excelFileName + ";Extended Properties=\"Excel 12.0 Xml;HDR=YES;IMEX=1;\";";
                      excelConnection = new OleDbConnection(conStr);
  
                  }
                  excelConnection.Open(); ***// this statement get the error!!!***
              }
              catch (Exception ex) { MessageBox.Show(ex.ToString()); }
  </code></pre>
  
  <p><strong>This is my connection strings:</strong></p>
  
  <p>string 1.</p>
  
  <pre><code>Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\~Projects IW\Desktop APPS\Maga\Book1.xls;Extended Properties="Excel 8.0 Xml;HDR=YES;IMEX=1;"
  </code></pre>
  
  <p>string 2.</p>
  
  <pre><code>Provider=Microsoft.ACE.OLEDB.12.0;Data Source=D:\~Projects IW\Desktop APPS\Maga\Book1.xlsx;Extended Properties="Excel 12.0 Xml;HDR=YES;IMEX=1;";
  </code></pre>
  
  <p>When reading xls file using connection string 1 get error </p>
  
  <blockquote>
    <p>"could not find installable isam"</p>
  </blockquote>
  
  <p>But reading xlsx file using connection string 2 ;it is works fine: NO Errors!</p>