BCP truncates record because of 2 extra chars in field read as a CRLF

greeting,

we have lots of users copy excel data rows , paste them flat file gets picked store procedure upload.  1 particular field seems contain extraneous characters bcp interprets crlf, bcp truncates rows, , generates row remainder of row.

looking through hex editor, see char(20) spaces.  i've tried various solutions nothing helps.

any ideas appreciated..

cl

hello,

did try use sql server import , export wizard? can custom row delimiter , column delimiter in wizard.

if issue presists, please post the sample data want import bcp utility. can workaround this.

regards,
fanny liu

---

we trying better understand customer views on social support experience, participation in interview project appreciated if have time.
helping make community forums great place.

SQL Server  >  SQL Server Tools