Forum Discussion
Solved
Error when importing CSV file
Hi, I am new at MS SQL and have the community edition in my local machine. Trying to import a CSV file but getting the following error message: Total Defect Qty:=SUM([Defect Qty]) TITLE: M...
It looks like contents in column Lable of the csv file is too long to insert into DB table, you should check the max size of column Label, and make sure the size of the column in DB table that import from Label is enough to contain the contents from the csv file.
For example, if the expression MAX(LEN(E:E)) of the csv file is 137, the column definition in DB table must not less than NVARCHAR(137).
By the way, which tool did you use to import csv?
Could you post the first 5 lines of the cvs file? and definition of all columns from the target table.