>>I'm trying to do a bulk insert:
>>
>>

>>BULK INSERT Import
>>   FROM 'c:\data.txt'
>>   WITH 
>>      (
>>         FIELDTERMINATOR ='|',
>>		 ROWTERMINATOR = '\r\n'
>>      )
>>

>>
>>I'm only getting the first row from the text file.
>
>Did you try to use \n for ROWTERMINATOR instead?

I played around with Bulk Insert a few weeks ago. In addition to what Naomi mentioned, you may want to check your rows to see if there is a "|" at the end of the row also. If there is, you will have to figure for that in your ROWTERMINATOR property.