OBDC error while importing data from Tally software

ODBC error while importing data from Tally software

Software provides an option to import data directly from Tally to IT Auditor Software.
Below error message appears when user tries to import trial balance from Tally.ERP 9 to Income Tax Auditor Software. This happens when ODBC and Tally.ERP 9 are not opened in administrator mode ( Run as administrator).


To resolve this problem while importing trial balance please follow the steps below:

Step 1:
  1. Close the entire software application both Spectrum and Tally ERP.9.
  2. Then go to the Tally shortcut available on the desktop
  3.  Right click on Tally shortcut icon and choose "Properties" option 
  4. Click on the "Open File Location" Button 
      v.  Right click on file “regodbc32” file and "Run as an administrator


      vi. Now, Open Tally  Select the company along with the Period to be imported.

      vii. Then open IT Auditor Software  Transactions  Balance Sheet   Import trial balance  Tally Direct. This would then import the data available in the tally to the Trail Balance.

Step 2:

If the problem still persists, then please check with the Tally ODBC Port available on the "Gateway of Tally" lower right area of the tally software.

The same port should be used in the IT Auditor software as well.


Tally Port is required to be entered into the software as shown in the below screen:



This will resolve the issue with ODBC in importing tally data to the IT auditor

NOTE:-  If after the process, yet there is issue in importing the data directly from the tally to IT auditor,
then there would be requirement to contact the Tally vendor so as to check if the data from
Tally is getting imported to Excel using Microsoft Query.

    • Related Articles

    • XML Tally Data Import - Tally Prime

      To import Trial Balance using XML Tally through Tally Prime, you are requested to please export the Trial Balance and List of account from Tally Prime application and then import the same in Zen IT Software. To Export Trial Balance using Tally Prime ...
    • Data Source name not found and no default driver specified

      Please note that this error normally occurs when "mysql-connector-odbc-3.51.12" is not installed on your system. The provided solution aims to resolve an error by reinstalling a specific driver. Here is a summarized version of the steps: Navigate to ...
    • Help file for importing Trial Balance directly from Tally

      User can eliminate repetitive work by importing trial balance from Tally directly and can prepare Financial reports like balance sheet, profit and loss, trading account etc. To import the Trial balance from Tally, please follow the steps provided ...
    • 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 ...
    • Error 127 Table Handler - [MYSQL][ODBC 3.51 Driver ]mysqld -4.0.13

      If there is any sort of malfunctioning in executing the software and due to any reason if the software gets automatically closed /shutdown, the user would encounter the error 127. Solution: Please follow the below troubleshoot (on server system of ...