Hi,

I have worked some with translation from Unix to PC encoding.

The main problem to BULK INSERT is that it has problems reading Unicode text documents as it does not have "CR" (Carrige Return) at the end of a row, only "LF".

By adding (there are some apps doing this, mainly on the UNIX side) a "CR" to the end of every line will solve the problem.

Also open the txt file in TextPad or NotePad++ and saving it in PC-format will do the trick.