|
|
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.
Navigation:
[Reply to this message]
|