Import Excel file raises error "Conversion failed when converting the nvarchar value ...to data type int." (4376434)

Chat now with support

Return

Did this article solve an issue for you?

[Select Rating]

Title

Import Excel file raises error "Conversion failed when converting the nvarchar value ...to data type int."
Description

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."
Resolution

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

Click To See Full Image.
Defect ID

TSS-2582
Additional Information

Waiting for fix in a future release, TSS-2582

Did this article solve an issue for you?

[Select Rating]

Title