TDS || Invalid file format or BCP Utility error while importing consolidate file

SOLUTION:

To resolve the  "Invalid file format or BCP Utility error" error which generally occurs while importing txt\tds\fvu file please go to  Tools > Option Settings,

Here set default path in all Export Utility Path and then OK.

            

            

Export Utility path is :

"C:\Program Files (x86)\K.D.K. Software\Spectrum\Zen TDS\Binn"      OR      "C:\Program Files\K.D.K. Software\Spectrum\Zen TDS\Binn"

Click on Default Path Tab for all the above paths and click OK. Try importing the file.​

If still problem persists then Go to Root Location of the software   C:\Program Files (x86)\K.D.K. Software\KDK Support      OR      C:\Program Files\K.D.K. Software\KDK Support

1. Run update.exe file. 
   

            

1. Click on Download Manager and OK.
   

            

1. Here Drag Down the Slider and Download > SQLNCLI for SQL Server 2008 R2.
   

            

1. Once file is downloaded, Install this file according to your system and after that try to import the TEXT or TDS file again.
   

This should resolve the issue.

• Related Articles

• TDS || Import Text or Consolidate(TDS) file

  The purpose of importing a text/Conso file is that all your old filed data gets into the software. You do not have to enter the master and transactions information of the Deductor and the Deductee again. To import the Text/TDS file into TDS software, ...

• TDS validation error - Invalid value in the field Deductee/Party records or value not as per file format

  TDS validation error - Invalid value in the field Deductee/Party records or value not as per file format Solution  This error would be come when we import the data from Excel template and change the predefined field in the Excel template. To solve ...

• TDS || Error 13 - Type Mismatch

  Solution: This issue is related to particular Client's database or Conso file issue. To resolve this please follow the steps below: Step 1: Please re-import the consolidate file through Export/Import – Import from Text/FVU/TDS file option and import ...

• TDS || Process for Consolidate file download

  The Conso file serves as a comprehensive compilation of data derived from processed statements, encompassing both regular and correction statements, pertaining to the relevant financial year, quarter, and form type. In the event of any modifications ...

• TDS/TCS FVU Validation error - Invalid value in the field Deductee/Part records or value not as per file format

  TDS/TCS FVU Validation error - Invalid value in the field Deductee/Part records or value not as per file format  Possible Solution  Usually this error comes when importing data from excel template  and 'section code' and 'challan serial. no'  is not ...