How do I import masters from Excel to Tally?

A Company "Global Enterprises" was using external software as on 31st March 2008. As on 1st April 2008, they have procured Tally.ERP 9. There is a requirement for all their ledgers and inventory masters to be transferred to Tally without entering them. The external software has an option to export its master data to Excel. Using the same, all ledger and inventory masters have been exported in Excel Sheets. The data files thus exported are displayed below. A Company Global Enterprises has been created in Tally.ERP 9 and only default masters exist as shown in the screen below: The data in Excel needs to be converted to Tally understandable XML format and sent to the port in which Tally.ERP 9 is running. To achieve this, an interface is built in VB to import all the masters from Excel and generate a Tally compatible XML which is subsequently posted in Tally.ERP 9. The interface application created for the same has been displayed below. On selecting Type "Stock Items" or "Ledgers" and clicking on Export to Tally button, it transfers all the relevant masters to Tally.ERP 9. On the Export to Tally Button, required XML as discussed earlier is constructed and posted to Tally.ERP 9 which is up at a predefined port. The XML is generated through the following VB Code Snippet:- On importing both Ledgers and Inventory Masters, statistics is as shown below: In the above figure, we can observe that 5 Ledgers and 6 Stock Items have been imported from Excel. If there are some errors while Importing, Tally.imp can be referred for Import Log. read less