Save Rs 588 on a 2-Year Ad-Free CAclubindia Pro Membership. Subscribe Now!

Tally ODBC

Save Share

This query is : Resolved

Jayendra Sahu (Querist)
Follow

20 September 2009 Tally ODBC helps establish a dynami connectivity of 7.2/9 with excel. When used for creating a trial balance in excel, we can then prepare B/S & P&L in excel as well that will adjust as per changes made in taly. My question is, such a trial balance is arranged in a certain way in excel and is connected via formula to cells in B/S n P&L. If we create a new A/c in tally this arrangement changes nd thus all the figures in B/S n P&L need to be connected again to the T.B. cells nd this disadvantage nulifies ODBC utility to a great extent since greater portion of excel sheets need to be reworked then. Is there a proper solution to this?

Ram Avtar Singh

Ram Avtar Singh (Expert)
Follow

20 September 2009 you can prepair Excel Trial by using Tally Trial.
Export trial In Excel then once again prepair other trial on next sheet by using Vlookup comod.then go to Balance sheet so every time it will work.

Message likes : 1 times

You need to be the querist or approved CAclub expert to take part in this query .
Click here to login now