Hi All,
We have a problem in Sql Server 7.0 while transferring data from text file to into a smalldatetime field of table. The data in text file has "dd/mm/yyyy" format. When we try to insert data to date field by using bulk copy method, we are getting this error.
"Server: Msg 4864, Level 16, State 1, Line 1
Bulk insert data conversion error (type mismatch) for row 182015, column 1 (TARIH)."
After the row '182015', the date data in text file is begining like this;
"13/03/2002".
Then, the problem has occured!!!!
P.S: We checked the reginol settings, the date setting of system is also "dd/mm/yyyy"
Does anyone has idea about this problem?
Thank u for your interest...
Tolga
We have a problem in Sql Server 7.0 while transferring data from text file to into a smalldatetime field of table. The data in text file has "dd/mm/yyyy" format. When we try to insert data to date field by using bulk copy method, we are getting this error.
"Server: Msg 4864, Level 16, State 1, Line 1
Bulk insert data conversion error (type mismatch) for row 182015, column 1 (TARIH)."
After the row '182015', the date data in text file is begining like this;
"13/03/2002".
Then, the problem has occured!!!!
P.S: We checked the reginol settings, the date setting of system is also "dd/mm/yyyy"
Does anyone has idea about this problem?
Thank u for your interest...
Tolga