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>;"
     
    Karthick MS likes this.


  2. Mukesh Kumar

    Mukesh Kumar New Member


    very informative. thanks
     


  3. ankurshah1985

    ankurshah1985 Member



  4. ankurshah1985

    ankurshah1985 Member



  5. Yogender

    Yogender Member



  6. Yogender

    Yogender Member



  7. Yogender

    Yogender Member



  8. Yogender

    Yogender Member



  9. PandeyICA

    PandeyICA New Member


    Please email your code arvindpandeyicaatom@gmail.com
     


  10. PandeyICA

    PandeyICA New Member


    Please email your code arvindpandeyicaatom@gmail.com
     


  11. Vikash Kumar

    Vikash Kumar New Member



  12. Srivalli R

    Srivalli R New Member


    hi


    [#Collection: Active Batches VchExtract],here i have to fetch a rate field, but it's won't take a value....
    any body can explain me or give a code
     


  13. NiravMerchant

    NiravMerchant Member


    kindly follow the steps to make both xl and tally bitness same
    close tally and xl
    open CMD command in Administrator Mode
    go to your tally installation folder
    type
    setup.exe /bitness:32 ( if ur xl is 32 bit and tally 64 bit)
    or
    setup.exe /bitness:64 ( if ur xl is 64bit and tally 32 bit)

    it works for me
     


  14. NiravMerchant

    NiravMerchant Member


    kindly follow the instruction after command it will ask to update tally
     


  15. rrpvansan

    rrpvansan New Member



  16. Amit Kamdar

    Amit Kamdar Administrator Staff Member



  17. rrpvansan

    rrpvansan New Member



  18. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    There is no TDL in this THREAD. This thread is about workability of 32 bit and 64bit.

    There are many others Excel to Tally Import TDLs in other threads. You can search for the same as per your requirements.
     


  19. Anil Mishra

    Anil Mishra New Member


    Install Tally 32 bit on your system
    there are one command in CMD

    setup /bitmess:32

    something like that
    search in google for right command
     


Share This Page