Ex-Tuts

Excel to Tally Utility                                                        where Data Entry becomes as easy as pie Excel to Tally Utility  is a Microsoft Excel tool that enables you to easily convert data to Tally application. It migrates all types data in Tally from Excel.   It is auto Tally data migration tool which helps migrate data quickly and easily. What you require to use this tool? A computer (With/Without admin access) Tally Application(Recommend Latest Version) Basic knowledge of Accounting Entries Basic knowledge of MS Excel. How to use this tool?          If you are using this tool for the first time, the tool will ask you for admin access and default folder to save the XML files.         If you have admin access to your system, then click here to kn...

What is ODBC? Open Database Connectivity (ODBC) is an interface for accessing data in a heterogeneous environment of relational and non-relational database management systems. ODBC is an Application Program Interface (API) specification that allows applications to access multiple database systems using Structured Query Language (SQL). ODBC provides maximum inter-operability a single application can access many different database systems. This allows an ODBC developer to develop an application, without targeting a specific type of data source. Steps to Link Excel with Tally : Step 1: Open a tally and select any company Step 2: On Gateway of Tally click “F12” for configuration settings Step 3: Select Advanced Configuration Step 4: Select  i) Tally.ERP 9 is acting as “Both ” ii) Enable ODBC Server to “Yes” iii) Port “9000” Step 5 : After you accept you will see the below screen