View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ben h[_2_] ben h[_2_] is offline
external usenet poster
 
Posts: 1
Default how does excel store new line and line feed characters?

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