CRM 3.0 Data Import with carriage return/endline RRS feed

  • Question

  • I'm trying to import data into CRM 3.0.  One of the fields I'm importing is a description with multiple lines of text (with carriage returns/endlines).  Even though these characters are enclosed in the quotes for the description field, the data import wizard sees them as record endings and tell me that I have too many headers/ too little data.


    I've tried Excel char(10) and char(13) with the same result.  Anyone suggest a way to achieve my goal (importing the carriage returns into the description field)?

    Thanks in advance!

    Thursday, January 3, 2008 9:26 PM


  • Dear,


    if you use nvarchar datatype, it will store all data mentioned in description field. you need  /r in your code.






    Thursday, January 10, 2008 1:56 PM