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

• How to import text/consolidate file in software

  How to import text/consolidate  file in software 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 ...

• 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 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/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 ...

• Text file import - Transactions record (challan enetry / dedcute entry) not showing

  Text file import  -  Transactions record (challan enetry / dedcute entry) not showing  Procedure to import text file  Click on Create new return ,the application auto-populates the fields like, Return Type , Financial Year , Quarter and form type ,  ...