I am trying to import text file into SQLServer table, bulk insert error out
on date time column here is statment I am using
BULK INSERT clrs..LOG_USER_ACTION2 FROM 'C:\test_log.TXT'
WITH (
BATCHSIZE=14,
DATAFILETYPE = 'char',
FIELDTERMINATOR = ',',
ROWTERMINATOR = '\n)
The file exported from Lotus Notes
and it looks like and table is
ID bigint no 8
NetworkID varchar no 25
Location varchar no 25
ActionID tinyint no 1
AppID tinyint no 1
SectionID int no 4
PatientNumber varchar no 50
Comment varchar no 250
AccessTime datetime no 8
AccessDenied bit no 1
docPK varchar no 50

1, 'selperin', '', 1, 19, 10020, '', NULL, '10/19/2004 5:36:02 PM', 0, NULL

Any help is appreciated.
Thanks
--
Farhan