Link to home
Start Free TrialLog in
Avatar of rastafaray
rastafarayFlag for United States of America

asked on

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
Avatar of Faizan Sarwar
Faizan Sarwar
Flag of United Kingdom of Great Britain and Northern Ireland image

try
Right click on database->Tasks->import data-> datasource =flat file source
browse your file and preview
Avatar of rastafaray

ASKER

ty sm394D

i am familiar with the method, but will it retain the line feeds?

Are you using SQL 2005 SSIS importing from a Text file:
Edit the source connection for FlatFiles, and change the Header Rows delimeter.
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
ASKER CERTIFIED SOLUTION
Avatar of Ernariash
Ernariash
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
great i will pay attention to the UI for this...

many thanks Ernariash