How to resolve a conversion failed when converting the nvarchar value error
If you get the following error message, there may be a special character in the data.
A nvarchar error indicated that there may be an invalid character in the file. Review the information in the error. In this example, it is: '134.'
- Search the document for the information contained in between the apostrophes.
- If there is a special character such as a decimal point you may need to format the cell.
- If you do not find the error by searching for the information between the apostrophes review the file for missing information or special characters.
Note: The error shown above included a decimal point that could not be seen in the file. When searching the file with just the numbers we found an envelope number 134. We reformatted the cell by copying the format for another cell that contained an envelope number that did not prompt an error and pasted the format into the cell. This eliminated the decimal point and resolved the issue.