locked
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

Answers

  • Dear,

     

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

     

    Regards,

    Imran

     

    http://microsoftcrm3.blogspot.com

    Thursday, January 10, 2008 1:56 PM
    Moderator