I was given a spreadsheet with item numbers and alternate item numbers. There are about 800 rows in the spreadsheet and it looks like this:
I am just clicking Tasks->Import inside SSMS. ALTITEM1 and ALTITEM2 import fine because no rows are missing any values and they correctly came over as nvarchar(255) as all columns are defined as text in Excel. However, ALTITEM3 and ALTITEM4 for same strange reason get converted to float even if I tell SSMS to treat them as nvarchar. How do I prevent this conversion? If I do tell it to use nvarchar the import does not work at all because it tells me invalid conversion. If I do not tell it to convert them all the values come over as NULL.