Import Excel file raises error "Conversion failed when converting the nvarchar value ...to data type int."
说明
When using Tools | Import Wizard | Add File (Excel file) and the file contains alphanumeric values, for example, "V0M4E2", the import wizard failed with message: "Conversion failed when converting the nvarchar value ...to data type int."
解决办法
Workaround 1: Convert the Excel file to a CSV Workaround 2: Using the Excel file, in the last step check the flag for the error