how does excel store new line and line feed characters?

B

ben h

I want to import a bunch of excel data into a unicode (NVARCHAR) field
in MS SQL which contains line feeds and all sorts. Is there a way to
transform the excel data so that it imports correctly? Either through
replacing the existing characters with unicode or some other way someone
else has tried?

Cheers,

Ben
 
Top