Yak Posting Veteran
Posted - 08/19/2013 : 05:54:52
FIELDTERMINATOR = ',',
ROWTERMINATOR = '\n'
I try to bulk data from a csv file.
I get below error message:
Bulk load data conversion error (type mismatch or invalid character for the specified codepage) for row 1, column 87 (xxxColumnNamexxx).
The column contain date data (2009/04/03).
I believe it is data format issue to database cannot accept.
May i know how should i upload this data with the right date format.
I prefer not .xml file because the csv file have about 90 column which i need to define all the 90 column and i have about 40 csv file have to bulk upload.
Is there any easier way?