Invalid file format / BCP Utility error

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


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.