Connect with Ms Sql server:

Discussion in 'Free Source Codes' started by NavaneethKrishna, May 9, 2019.

    
  1. NavaneethKrishna

    NavaneethKrishna New Member


    Hi,
    following tdl code sample ledger data import from sql server database:
    perfectly work for me.

    [Collection : Led Coll]
    ODBC : "Driver=SQL Server;Server=DESKTOP-CG5O5EP;Database=Tally;Trusted_Connection=True;Uid=sa;Pwd=SA2012;"
    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
    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


    thanks.
     
    Sudhir83411 likes this.


  2. tanzeel

    tanzeel New Member


    Can you make it reversal to Export Data from Tally to SQL Server
     
    Sudhir83411 likes this.


Share This Page