Conversion failed when converting the nvarchar value '15L' to data type int
说明
When importing data from Excel into a table in SQL Server using the Import Wizard, the following error appears:
'Conversion failed when converting the nvarchar value '15L' to data type int.'
This happens even if the datatype of the target column is nvarchar, not int.
解决办法
WORKAROUND: Whilst in the section of the Import Wizard that asks you to save a template, save log and Discard file, please ensure to fill out all these fields, and the import will succeed.
STATUS: Waiting for fix in a future release of Toad Data Point
