SqlBulkCopy Received An invalid column length from the bcp client for Colid 5.

SqlBulkCopy Bulk Copy Error: Received An invalid column length from the bcp client for Colid 5.

Translation: received a column length that is not valid for Colid 5 from the bcp client

That is, the imported Excel 5th column length is very long, the check found that the fifth column "name" has a name is the company name is very long,

The database definition type is varchar (50) and the name of the man is 26, which requires at least a length of varchar (52),

Shorten the name change to solve the problem.

Reference Link: http://blog.lixin.me/archives/29385/

SqlBulkCopy Received An invalid column length from the bcp client for Colid 5.