Exporting Stock Item’s Part Number to Excel through ODBC

No Comments

With Open Database Connectivity (ODBC) you can dynamically exchange data between Tally.ERP 9 and any other application dynamically. Using ODBC feature, you can transfer data from Tally.ERP 9 to Microsoft Word or Excel. Currently, while extracting Stock Item details from Tally.ERP 9 to Excel, the Part Number specified in the respective item is not being fetched through ODBC.


Create the required excel through ODBC and insert a new column manually as StockItem.`$MailingName’. Then in Tally.ERP 9, go to Stock Summary and in F12: Configuration, for the option “Appearance of Stock Item Names” select the appearance type – Name (Part No). After this configuration go to List of Accounts, report displays the item name with the part number. From List of Accounts, Export the stock item details to Excel. The Exported Stock Details will contain the Part Number along with other details. From this excel copy the data in Part Number column and paste in StockItem.`$MailingName’


Resolution for the above stated problem will be provided in Tally.ERP 9 Series B JAS (July, August, September) Release.

    About us and this blog

    RK Solutions is an authorized solution provider of Tally Solutions Pvt. Ltd. for its various products & services Located at Chennai, India, the company has been providing scalable, reliable, and highly efficient solutions to clientele across the World.

    Request a free quote

    We offer professional SEO services that help websites increase their organic search score drastically in order to compete for the highest rankings even when it comes to highly competitive keywords.

    Subscribe to our newsletter!

    More from our blog

    See all posts
    No Comments