Posted by ckirby on 12/28/05 17:44

thanks for the 'Tough Love'.. I modified the BULK INSERT to :

BULK INSERT dbo.tmpPaTimeClock
FROM Path... WITH (DATAFILETYPE = 'char',
, FIRSTROW = 3
, FIELDTERMINATOR = ','
, ROWTERMINATOR = '\n')

and that did the trick. It splits the first column in 2 because of the
comma seperating the names, but that's really not a problem for me,
since I'm not using that field(s). But if anyone know how to prevent
that , I'd like to learn.

[Back to original message]