Submitting forms on the support site are temporary unavailable for schedule maintenance. If you need immediate assistance please contact technical support. We apologize for the inconvenience.
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