rastafaray
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
01.gif
ASKER
ty sm394D
i am familiar with the method, but will it retain the line feeds?
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.
ASKER
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
i've done flat file imports before, but still unclear as to what char code translated into a line feed
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
great i will pay attention to the UI for this...
many thanks Ernariash
many thanks Ernariash
Right click on database->Tasks->import data-> datasource =flat file source
browse your file and preview