borgkling2003
MIS
Im getting this error when I try doing a bulk insert:
Server: Msg 4864, Level 16, State 1, Line 1
Bulk insert data conversion error (type mismatch) for row 2, column 3 (last_sales_date).
This is how the txt file looks like:
ID,NAME,LAST_SALES_DATE
----------------------
10|Terry|30/06/1999
In the database the LAST_SALES_DATE field type is set to DATETIME.
Can someone please help me with this? Below is the bulk insert I am using
BULK INSERT CUSTOMER_DEALER FROM '\\test\customer_dealer.txt' WITH (MAXERRORS=0, FIRSTROW=2,FIELDTERMINATOR = '|');
Server: Msg 4864, Level 16, State 1, Line 1
Bulk insert data conversion error (type mismatch) for row 2, column 3 (last_sales_date).
This is how the txt file looks like:
ID,NAME,LAST_SALES_DATE
----------------------
10|Terry|30/06/1999
In the database the LAST_SALES_DATE field type is set to DATETIME.
Can someone please help me with this? Below is the bulk insert I am using
BULK INSERT CUSTOMER_DEALER FROM '\\test\customer_dealer.txt' WITH (MAXERRORS=0, FIRSTROW=2,FIELDTERMINATOR = '|');