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

    • ExpressGST || Process for Importing GSTR-9 Book Data via Tally

      Process for Importing GSTR-9 Book Data via Tally into Express GST The following steps provide a professional guide for importing GSTR-9 book data from Tally into Express GST: Step 1: Select the Client Log in to https://www.expressgst.com/ and ...

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

    • ZenIT || Trial Balance Import via Tally XML Files - Tally Prime

      To import the trial balance using XML from Tally Prime, please export the Trial Balance and the List of Accounts from the Tally Prime application and then import them into the Zen IT software. To Export Trial Balance using Tally Prime Software, ...

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