Forum Discussion
Importing Data from Excel to SQL table
I am getting truncation errors while importing Excel spreadsheet to SQL table. Not quite sure how to fix this. My column in SQL table is plenty long enough to hold the contents of column. Here are th...
It would seem that you have one or more characters that are not being recognized by the code page you are using. Change data type for destination column to nvarchar(xx) Unicode. That should do it I suspect.
I do have all my columns set to nvarchar and still getting the truncation error. Any other ideas?
