How do I import data from a spreadsheet / csv file with carriage returns in the data?

How do I import data from a spreadsheet / csv file with carriage returns in the data?


I am trying to import data into a creator database from a spreadsheet, and one of the columns has carriage returns. Do I need to conver the carriage returns to another character to load the data, or am I just totally missing something in the load?

Thanks.