title: OleDb Read Excel not reading all rows after publish to IIS (File size issue)
body: <p>I am reading excel using oledb provider with following connection string:</p>
  
  <p><strong>"Provider=Microsoft.ACE.OLEDB.12.0;Extended Properties=Excel 12.0 XML;Data Source=FileName.xlsx;"</strong></p>
  
  <p>and then I am just reading records by "select * from ......." into data reader.</p>
  
  <p>With above connection string and code I am able to read all (small,large with almost 45000 records) excels in development mode i.e. in debug mode.</p>
  
  <p>But when I publish same code in IIS then only 27043 rows are getting read, not all rows. (Issue seems with filesize not with no.of records)</p>
  
  <p>I checked at other question at stackoverflow which has answer to change <strong>IMEX</strong> value to 1 but this change not helping me.</p>
  
  <p>All the code working fine in debug mode so I wonder why its not working after publish??</p>
  
  <p>If any of you have faced such issue, please assist.</p>
  
  <p>Thanks.</p>