Will EXCEL import SQL database can be successful, but one of them in the EXCEL data content is more, usually 560 words, often appear after the import database, query the content is not complete, lack some of the words, but not all of them are missing, the other is no problem, can this how to solve?

CodePudding user response:

Look at what is your defined field type, it is not because of the length is not enough, the truncated

CodePudding user response:

Field is defined as a nvarchar (Max), guide again

CodePudding user response:

Definition is Max, but there are still some missing content,

CodePudding user response:

reference 1st floor lhz_dxm response:

see you define what is the field of type, it is not because of the length is not enough, the truncated

Definition is Max, but there are parts missing

CodePudding user response:

reference evil flow garden reply: 3/f

definition is Max, but there are still some missing content,

Definition is Max, but there are parts missing

CodePudding user response:

Office of plug-in, it is recommended that the installation official recognition of the office a try, if installed WPS may appear such mistakes!