Forum Discussion

naveen73's avatar
naveen73
Copper Contributor
Nov 16, 2024
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...
csv
Importing data
mssql
nvarchar
  • rodgerkong's avatar
    rodgerkong
    Nov 20, 2024

    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?

naveen73's avatar
naveen73
Copper Contributor
Nov 18, 2024

Hi,

 

Thanks for taking the time to respond. The file is large and the rows that is being referred to in the message I have attached in the file.

Any solutions are much appreciated.

thanks,

 

Naveen

rodgerkong's avatar
rodgerkong
Iron Contributor
Nov 20, 2024

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?

  • naveen73's avatar
    naveen73
    Copper Contributor
    Nov 20, 2024

    Thanks so much.

     

    I used the Import wizard

Resources