How to Import DBF data in tally

Discussion in 'Free Source Codes' started by Hem Singh, Nov 22, 2018.

    
Tags:
  1. Hem Singh

    Hem Singh New Member


    Hello Sir

    Plz help me for import Ledger master from DBF file
     


  2. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    kindly open your DBF file in excel and convert it to XML format or XLS format or XLSX format.

    Then use any utilities available on this forum to import your data into Tally.

    You can search. there are many import TDLs available here.
     


  3. Devendra_Rawat

    Devendra_Rawat Well-Known Member



    May I help you.
     


  4. NAGARAJKMAR SUBRAMANIAN

    NAGARAJKMAR SUBRAMANIAN Active Member


    Which dbf

    You can connect any dbf thru ODBC from Tally

    Check connectionstrings.com for connection string according to the dbf type

    in tally create a collection using the connections string

    then write code to import data

    This is the Procedure.
     


  5. Hem Singh

    Hem Singh New Member


    Hello Sir help me I want to import item master MRP Rate

    error : Function: Label: 230: Action Execution failed!

    210 : INSERT COLLECTION OBJECT : MRPDETAILS
    220 : Set Value : FROMDATE : $$Date:#GSTItemImportDate

    221 : INSERT COLLECTION OBJECT : MRPRATEDETAILS
    222 : Set Value : STATENAME : $$SysName:Any
    230 : Set Value : MRPRate : $$Number:230 ;If $$IsEmpty:$$FileReadCell:##RCnt:20 Then "" Else $$Number:($$FileReadCell:##RCnt:20)
    240 : Set Target : ..
    241 : Set Target : ..
     


  6. NAGARAJKMAR SUBRAMANIAN

    NAGARAJKMAR SUBRAMANIAN Active Member


    Try this

    230 : Set Value: MRPRate: $$Tgtobject:$$AsRate:$$Number:230
     


Share This Page