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
    2. use SQL Server Import and Export Wizard to import the excel file.