title: Excel: 2007-2013 TypeGuessRows - Character Value
body: <p>I need to import an excel 2007-2013 file into MSSQL but the characters are being truncated within a column. The quick fix is to sort the rows from largest to smallest interns of character sting length. </p>
  
  <p>I require a permanent solution and the following answer (see below) worked for .exe files however what will be the corresponding solution for .xlsx files.</p>
  
  <p>Thanks 
  Chantelle</p>
  
  <blockquote>
    <p>To change the value of TypeGuessRows, use these steps: 1.On the Start
    menu, click Run. In the Run dialog box, type Regedt32, and then click
    OK. 2.Open the following key in the Registry editor:</p>
    
    <p>HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0\Engines\Excel</p>
    
    <p>Note For 64-bit systems, the corresponding key is as follows:</p>
    
    <p>HKLM\SOFTWARE\wow6432node\microsoft\jet\4.0\engines\excel
    3.Double-click TypeGuessRows. 4.In the DWORD editor dialog box, click Decimal under Base. Type a value between 0 and 16, inclusive, for
    Value data. 5.Click OK, and then exit the Registry Editor. </p>
    
    <p>A second way to work around this problem (without modifying the
    registry) is to make sure that rows with fields, which have data 255
    characters or greater, are present in the first 8 rows of the source
    data file. shareedit</p>
    
    <p>answered Jan 20 '14 at 11:21</p>
    
    <p>Suji 112</p>
  </blockquote>