UNIX for Dummies Questions & Answers

I know this is the wrong place to post this, but I haven't gotten any response from the post I put on Microsoft's forum.
There is in SQL2000 a "bulk insert" statement that allows appending a delimited file into an existing table. The problem that I am having is that I can only load one record at time, otherwise I get a msg4866, complaining about the end-of-record character.
The default is fields separated with a tab, and terminated with a linefeed only (unix?). I have tried adding a tab after the last field, but that doesn't make any difference either.
If anybody has any suggestions I would appreciate them.

I suggest you terminate each line with carriage-return then line-feed.

I tried that, and guess what, it works.
Here's the Microsoft manual page:

ROWTERMINATOR [ = 'row_terminator' ]

Specifies the row terminator to be used for char and widechar data files. The default is \n (newline character).