title: Data truncated after 255 bytes while using Microsoft.Ace.Oledb.12.0 provider
body: <p>I am reading an excel sheet using the ACE provider and certain cells contain data greater than 255 bytes. I tried changing the TypeGuessRows in the registry settings as well as setting the same from the connection string. Still I get the truncated value in the code. I am not in a position to restructure the excel sheet or use another provider. I run 64 bit windows. My office edition is 2013. (Have a small doubt if it is because of this). </p>
  
  <p>This is my connection string; it is working fine for those cells having data &lt; 255 bytes. </p>
  
  <pre><code>var connectionString = string.Format("provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + fileName + ";Extended Properties=\"Excel 12.0;IMEX=1;HDR=YES;TypeGuessRows=0;ImportMixedTypes=Text\"");
  </code></pre>
  
  <p>Any solutions? Thanks in advance.</p>