title: Import Excel file that has carriage return / line feeds within cells into SQL Server 2008 R2 and preserve the carriage return / line feeds?
body: <p>Is it possible to import an Excel file that has carriage return / line feeds within cells into SQL Server 2008 R2 and preserve the carriage return / line feeds? The Excel file has about 81,000 rows. </p>
  
  <p>I tried using the import wizard with no success. I ended up creating the table and then cut and pasting the rows in, but the order skews when it gets to the cells that have the carriage return / line feeds. Anyone know of a fix for this?</p>
  
  <p>I'm importing into a SQL Server 2008 R2 database from Excel 2007. The Excel file has cells that have carriage return / line feed. The error I receive is truncation and special character issues -- same issue even when I change to <code>varchar(max)</code> or <code>nvarchar(max)</code>. So I gave up and created the the table without row data, then cut and pasted the rows from Excel directly into SQL Server 2008 R2. The issue during cut and paste is with the cells that have the carriage return / line feed.</p>