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

    • ExpressGST || Import GSTR2 Data from Tally to Express GST

      ExpressGST | Importing GSTR-2 Data from Tally The following steps and prerequisites are essential for accurately importing GSTR-2 data from Tally into ExpressGST. Meeting these criteria ensures precise mapping and successful data import. ...

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

    • Income tax || How to Importing Trial Balance directly from Tally

      Importing Trial Balance directly from Tally: User can eliminate repetitive work by importing the trial balance from Tally directly and preparing financial reports like the balance sheet, profit and loss, trading account, etc. To import the trial ...

    • Express ITR || How to Import Trial Balance From Tally

      What is Trial balance A trial balance is a financial report used in accounting to ensure that the total of all debit balances equals the total of all credit balances. It’s a preliminary step in preparing financial statements and helps to identify any ...