Excel to Tally import TDL code is not working in Tally64 bit exe.32 bit Excel installed in my System

Discussion in 'Knowledge Base' started by admin, Nov 12, 2015.

         
  1. admin

    admin Administrator Staff Member


    Query

    Excel to Tally import TDL code is not working in Tally64 bit exe.32 bit Excel installed in my System.

    Solution

    Ensure that both Tally and MS Office are of same bit ness. i.e. if both applications are of 32 bit or 64 bit then both can communicate without any problem.

    If Tally application is 64 bit and acting as client and MS office (i.e Excel is 32 bit acting as Server) then ideally they cannot communicate with each other. However you can follow below steps to make both applications communicate with each other by using ODBC interface

    Install AccessDatabaseEngine_x64.exe by following the below steps:-

    a) Download the file - AccessDatabaseEngine_x64 to local system
    b) Open Command prompt with administrative rights
    c) Change Directory to exact file location. (Where the file AccessDatabaseEngine_x64 is located)
    d) Type this command and Enter -> AccessDatabaseEngine_x64/passive
    e) Once the Exe is installed. Re-start the Tally and proceed with the Import.

    Further, to read an Excel File irrespective of the formats, one can use the following connection string:
    "Driver={Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb)};DBQ=<Complete Path with File Name>;"
     



Share This Page