Hello,
I'd like to import from an ascii text file where the fields are delimited by
semicolon (strings and texts are further enclosed in quotes) and rows by
carriage return. However, some text fields contain line feeds themself. I've
already tried to create a .fmt file to be used with bcp, but it still fails:

Starting copy...
SQLState = S1000, NativeError = 0
Error = [Microsoft][ODBC SQL Server Driver]Unexpected EOF encountered in BCP
data-file

Is it possible, that bcp mistakenly first tries to parse the entire row
before it breaks it down to fields by using the delimiters?!
What can I do to achieve a proper import?


Thank you,


Dirk

You have to use delimiters that are not found in the fields. They can be as
odd as µ.

Ilya

"Dirk Pass" <newsgroup-news (AT) dirk-pass (DOT) com> wrote