.neo


Hi,

This might be a noob question, but is there any way to specify just <lf> as a line delimiter, and not <cr><lf> (/n) as line delimiter in T-SQL call for BULK INSERT (or BCP utility). How please TIA.




Re: BCP (BULK INSERT) with only <lf> as line delimiter (not <cr><lf>)...

KeWin


Usually any of these three combination would work for all kinds of files.

/n
/r
/r/n

You might try /r first, I think that's the one you need if /n doesnt' work.

/Kenneth