Excel Import SQL Server Error-"text truncated, or one or more characters do not match in target code page" error resolution

Some people say you should turn to access first and then to SQL Server. In fact, the use is not big, to truncate or be truncated.

The reason is that the import and export of SQL Server determines the field type of the data table, taking the first 8 lines of the Excel file. If the first 8 is a string of less than 255, it is set to the nvarchar (255) type, but if there are more than 255 lengths in the records after Excel, an error occurs when importing. It is not possible to adjust the length of the field even when you import the settings map.

The solution is to change the registration form

If yes: Jet engine.
Hkey_local_machine\software\microsoft\jet\4.0\engines\excel

If yes: Ace engine.
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\12.0\Access Connectivity Engine\Engines\Excel
Then find TypeGuessRows this item. The default is 8. Modified to 0.

Excel Import SQL Server Error-"text truncated, or one or more characters do not match in target code page" error resolution