tips (en)‎ > ‎

microsoft

how to import an excel column with numbers to ms sql as nvarchar (not as float)
  1. add a tick ' before each number, so the number is treated as text (if you have a great number of rows, you may use this tip "How to add text to the beginning or end of all cells in Excel?" at http://www.extendoffice.com/documents/excel/670-excel-add-text-to-beginning-end-of-cell.html)
  2. use SQL Server Import and Export Wizard to import the excel file.
Comments