title: Delphi ADO with Excel 2010 or newer, problems with .RecordCount
body: <p>I have a case here where I use excel files connected with ADO, it seems OK with excel 2003 files, however when I use excel 2007 or newer I get some problems receiving recordcount..</p>
  
  <p>my connection string look like this for excel 2003 : </p>
  
  <pre><code>format('Provider=Microsoft.Jet.OLEDB.4.0;Data Source=%s;Extended Properties=Excel 8.0;',[filename])
  </code></pre>
  
  <p>and the same connectionstring for excel 2007 or newer (xlsx files)</p>
  
  <pre><code>format('Provider=Microsoft.ACE.OLEDB.12.0;Data Source=%s;Extended Properties="Excel 12.0 Xml;HDR=YES;IMEX=1"',[filename])
  </code></pre>
  
  <p>do I need something more here? or what am I missing to be allowed to use the recordcount, recno etc etc?</p>