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
- Run update.exe file.
- Click on Download Manager and OK.
- Here Drag Down the Slider and Download > SQLNCLI for SQL Server 2008 R2.
- 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.