how to import fields with line feeds into SQL

is there a way to import fields with line feeds?   see attached screen-shot
01.gif
rastafarayAsked:
Who is Participating?
 
ErnariashCommented:

Using the wizard is similar to SSIS :You will have the option to select the Header Row Delimeter:
{CR}{LF}
{CR}
{LF}
Semicolon {;}, and so on & 
Systems based on ASCII or a compatible character set use either LF (Line feed, 0x0A) char(10) or CR (Carriage Return, 0x0D) char(13) individually, or CR followed by LF (CR+LF, 0x0D 0x0A).
If you change the Header Row Delimeter to something else (depending your file) it will import the ASCII  newline or LF to fields with line feeds.
0
 
sm394Commented:
try
Right click on database->Tasks->import data-> datasource =flat file source
browse your file and preview
0
 
rastafarayAuthor Commented:
ty sm394D

i am familiar with the method, but will it retain the line feeds?
0
Cloud Class® Course: Amazon Web Services - Basic

Are you thinking about creating an Amazon Web Services account for your business? Not sure where to start? In this course you’ll get an overview of the history of AWS and take a tour of their user interface.

 
ErnariashCommented:

Are you using SQL 2005 SSIS importing from a Text file:
Edit the source connection for FlatFiles, and change the Header Rows delimeter.
0
 
rastafarayAuthor Commented:
this is SQL 2005 but not SSIS, simply right click on dbase | all tasks | import etc etc.

i've done flat file imports before, but still unclear as to what char code translated into a line feed
0
 
rastafarayAuthor Commented:
great i will pay attention to the UI for this...

many thanks Ernariash
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.