title: Text was truncated or one or more characters had no match in the target code page
body: <p>I want to import .xlsx file data in MS SQL SERVER 2008. So, using SQL Server import and export wizard I start to import by selecting .xlsx file. Here I got the error "Text was truncated or one or more characters had no match in the target code page".</p>
  
  <p>I tried google it and I got 2-3 solution and I start trying those one by one.</p>
  
  <ol>
  <li>I tried change data type size to nvarchar(max) --- not work</li>
  <li>I tried by adding more then 255 character in particular column and give size nvarchar(max) --- not work</li>
  <li>I tried save .xlsx file to .csv and start importing by selecting data source flat file --- not work</li>
  <li>I also tried selecting DT_NTEXT --- not work</li>
  </ol>
  
  <p>Please explain me how do I complete this task?</p>
  
  <p>Thank you.</p>