The cause: That happens when we attempt to insert string data (varchar, nvarchar, char, and nchar) into columns that are larger than the column’s size.

Solution: You can fix this error by creating an XLSX file and importing. It accurately detected the data type instead of setting all columns as varchar(50) . Turns out nvarchar(255) for that column would have done it too.