title: SQL Server data raises truncating error when exporting to Excel
body: <p>I'm trying to export my SQL data to an Excel file and I'm getting a truncating error because of the exceeded character's length from one of my SQL table's columns. But when I import from Excel into SQL, I get the complete value from Excel even one of its column is exceeded to 255 in its length. </p>
  
  <p>I tried to set the <code>ImportMixedTypes</code> registry of <code>LOCAL_MACHINE</code> to Majority Type but no  luck. I need to transfer the data to Excel file so it can be easily read. I hope somebody could give me hint or idea to solve this problem.</p>