title: Delphi - Excel rows get by an ADO Query
body: <p>I have the following excel file </p>
  
  <p><img src="https://i.stack.imgur.com/2ukXO.jpg" alt="enter image description here"></p>
  
  <p>I set AdoConnection.ConnectionString to </p>
  
  <pre><code> AdoConnection.ConnectionString :=' Provider=Microsoft.Jet.OLEDB.4.0;' +
             'Data Source=' +aFileName + ';' +
             'Extended Properties=Excel 8.0;';
  </code></pre>
  
  <p>where aFileName is the excel file name.</p>
  
  <p>After that, with an ADOQuery component(connection set to AdoConnection) I perform a 'select * from [Sheet1$]'. </p>
  
  <p>The problem is that rows 16802 and 17179 are not present in the query result,and I don't know why. All the fields from the sheet are set to general. I'm using Delphi 7.</p>
  
  <p>Do you have any ideas?  </p>
  
  <p>LE:type of all the fields from the AdoQuery are WideString. In query are present only the rows where values from the last 2 columns have that 'green sign'. I'm not a genius in Excel, but the query should not get all the data existing in a sheet?</p>