title: Truncation errors trying to import from Excel
body: <p>I'm trying to import the NDC database that you can download here: <a href="http://www.fda.gov/drugs/informationondrugs/ucm142438.htm" rel="nofollow">http://www.fda.gov/drugs/informationondrugs/ucm142438.htm</a></p>
  
  <p>When I initially tried to import the excel in the zip file it complained about the format, so I started with a blank excel, and imported it into excel from the txt file.</p>
  
  <p>I've created a table to import the data into and set all the columns to nvarchar(MAX).  The column it complains about is the SUBSTANCENAME column.  I checked, and the longest value in that column is about 2700 characters.</p>
  
  <p>My understanding is that the nvarchar(MAX) should easily hold that much.  I'm not sure what to do about this other than changing that column to a text field.  Should that fit into that column how it is?</p>
  
  <p>I've tried setting it to ignore errors, but as far as I can tell that does nothing, at least it never seems to ignore them when I try.</p>