Procedure for using ODBC software for transferring data

Start Tally and select the company from where you want the data to be extracted. Minimize Tally and open ODBC compliant software.
Here I will explain it using MS-Excel.
Open MS-Excel and select the menu 'Data' at the MS-Excel window, then select 'Get external Data' then select 'New Database Query'. Then select "TallyODBC" of Database tab.
Tally then connects to data source and displays the 'Query Wizard'. Select the column you want to include.
Excel displays all the columns as the columns are selected.

Tally Open Database Connectivity(ODBC)

Tally data can be embedded into other ODBC compliant software like MS-Excel, MS-Word, Visual Basic, etc by installing Tally ODBC driver. Tally data driver can be made available to external applications. Tally Data can be viewed too.

Open Database Connectivity - ODBC

Any program like MS-Excel, Oracle, etc. that is ODBC compliant can use data from Tally as Tally is ODBC compliant. Any changes in Tally will be reflected in the ODBC compliant software as the data connectivity here in Tally is dynamic in nature. Through this facility data can be extracted from Tally and the report extracted can be designed as per the users requirement.