TDS Correction Excel Import "Error converting data type varchar to numeric"

TDS Correction Excel Import "Error converting data type varchar to numeric"

TDS Correction Excel Import Error:- 2147217913 Error converting data type varchar to numeric



















Possible Resolution


To solve this excel import issue, here are some suggestions are given below. 

1. In the Excel template, it is to be checked that the Section Code is selected from the drop-down (pre-specified in software template ) or not.



2. In the Excel template, it is to be checked that the Deductee Code is selected from the drop-down (company/non-company ) or not.




3.  In the Excel template, it is to be checked that the Challan Serial No. is selected from the drop-down or not.


4. Deductee name should not be greater than 75 characters.

5. Pan Number should not be greater than 10 characters and pan number should be as per pan number format.

6.Tds correction  Excel template should be TDS software only

Hope This Helps