Import Excel to Tally TDL Code | Excel to Tally XML format
There are different method available for Excel to Tally integration. Most of Tally TDL code or XML code uses for Excel to Tally data migration. With help Tdl source coding, any type of vouchers, masters and any data can import in Tally from Excel.
You can create Tally Tdl tags XML code with Microsoft Excel VBA for import vouchers and masters data. Use Following basic code to import vouchers in Tally.
Follow Excel VBA code create XML file with TDL tags -
"Sub ExcelTallyXml()
Dim XmlCode As String
'Add Loop Function to Repeat XmlCode String ******
XmlCode = "<TALLYMESSAGE xmlns:UDF=""TallyUDF"">"_
"<VOUCHER VCHTYPE="" ACTION="Create">"
<VOUCHERTYPENAME></VOUCHERTYPENAME>
<VOUCHERNUMBER></VOUCHERNUMBER>
<REFERENCE></REFERENCE>
<REFERENCEDATE></REFERENCEDATE>
<DATE></DATE> 'Write Reference Cell Address
<PARTYLEDGERNAME>Sachin</PARTYLEDGERNAME> ''Write Reference Cell Address
<ALLLEDGERENTRIES.LIST
<REMOVEZEROENTRIES>No</REMOVEZEROENTRIES>
<ISDEEMEDPOSITIVE>No</ISDEEMEDPOSITIVE>
<LEDGERFROMITEM>No</LEDGERFROMITEM>
<LEDGERNAME>Sachin</LEDGERNAME>
<AMOUNT> 500</AMOUNT> 'Write Reference Cell Address
</ALLLEDGERENTRIES.LIST>
</VOUCHER>
</TALLYMESSAGE>"
End Sub"
Follow these steps to Import XML in Tally ERP -
- Create XML file with above mention VBA code
- Save XML file in particular drive
- Open Tally ERP & select Company
- Select IMPORT OF DATA option
- Write full path of saved XML file
- Press ENTER
- Data will be imported in Tally
- Done.
In Vba code you can Loop function so you can create single XML file for multiple vouchers import. Make the changes in VBA code as per your requirements.
