MS Access to Tally import issue

Discussion in 'Requests' started by zakirhossain_diu, Feb 4, 2020.

         

  1. Dear Developers,
    I am trying below codes as copied from samples while importing its just showing Process completed.
    Any suggestions
    Code:
    [Collection : Led Coll]
              ODBC :  "Driver={Microsoft Access Driver (*.mdb)};Dbq=D:\Masters.mdb;Uid=;Pwd=;"
             SQL : Select * From LedgerMaster
              SQL Object : AccessObj
    
    [Object : AccessObj]
               LedName : $_1
               LedParent : $_2
               LedOpBal : $$AsAmount:$_3
              
    [#Menu: Gateway of Tally]
              Add  :  Item  :  Ledger Import  :  Call   :   Ledger Import
    
    [Function: Ledger Import]
              01 : WALK COLLECTION  :  Led Coll
              02 : NEW OBJECT : Ledger ;: $LedName
              03 : SET VALUE : Name : $LedName
              04 : SET VALUE : Parent : $LedParent
              05 : SET VALUE : Opening Balance : $LedOpBal
              06 : SAVE TARGET
              07 : END WALK
              08 : MSGBOX : "Status" : "Process completed successfully!!"
              09 : RETURN
    
    
    from anyone.

    Thank you
     

    Attached Files:



  2. garima

    garima Active Member


    Colection do not have data, check access file name and path, name of table in access (LedgerMaster) table in access, you are referring to..
     
    zakirhossain_diu likes this.



  3. Also Note, Long back, I found some problem with "Tally ODBC 32/64bit Driver" w.r.t. Win10 64bit OS
     
    zakirhossain_diu likes this.



  4. Any way to avoid this problem?
     


Share This Page