HOW TO LINK TALLY AND EXCEL USING ODBC (ONLY FOR EXCEL TO TALLY TOOL)

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