1. CLICK HERE TO JOIN WHATSAPP CHANNEL FOR TDL PROGRAMS

Import Data from Oracle and/or SQL into Tally

Discussion in 'Tally Integration' started by G Vijay, Nov 10, 2012.

    
  1. G Vijay

    G Vijay Member


    Dear All,

    I'm import the data from Oracle / Sql into Tally, very tedious way.

    Can you please help me, is there any TDL code for importing data from oracle and SQL into Tally.ERP 9

    Thanks in Advance
    G Vijay

    Wish you & Your Family very happy Diwali. :)
     
    G Vijay, Nov 10, 2012
    #1


  2. admin

    admin Administrator Staff Member


    It is just simple as import from Excel.

    In the collection, you need to mention the ODBC Connection string.

    [Collection: test ]
    ODBC: <Write ODBC Conenction here>
    SQL: <Write SQL Statement here>
     
    admin, Nov 10, 2012
    #2


  3. G Vijay

    G Vijay Member


    Dear Sir,

    Can I get sample code?, please..... since i have to import data from Oracle, it has more than 1.2Lakh vouchers.

    Thanks in Advance
     
    G Vijay, Nov 11, 2012
    #3


  4. G Vijay

    G Vijay Member


    HI,

    Any Updates please i need it very urgently....
    Thanks & Regards.
     
    G Vijay, Nov 20, 2012
    #4


  5. divya panyam

    divya panyam New Member


    hELLO Sir,

    You can use the connection settings like thisAnd then from this collection ,you need to write a function

    [Collection : LedgerMasterFromSQLSrc]
    ODBC : "Driver={SQL Server};Server=[server name];Database=[Db Name];Uid=[user name];Pwd=[password];"
    SQL : This is a sample query;;Select strLedgerName,(Select strHeadName from dbo.tblaccountheads accgrps +
    where accgrps.ID_AccHead = ledmaster.ID_Acc_SubHead)as Parent,+
    decOpeningBal,intOpeningBalType+
    From dbo.tblledgermaster ledmaster
     
    divya panyam, Sep 23, 2013
    #5
    zakirhossain_diu likes this.


Share This Page