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