skip to Main Content
+91-9551052100 Download Pay Help

To extract information from the ledger master to Excel, such as shown below:

To extract ledger data to Microsoft Excel

A. First click here to Enable ODBC in Tally

1. Open Microsoft Excel on your computer.

2. Click Data Get External Data From Other Sources From Microsoft Query , as shown below:

3. Select TallyODBC64_9000* , as ODBC is enabled on the server 9000.

4. Click OK . The Query Wizard – Choose Columns screen appears as shown below:

5. Click Ledger and expand the list to select the required fields.

6. Click Next . The Query Wizard – Filter Data screen with the column names appears as shown below:

7. Click Next . The Query Wizard – Sort Order screen appears as shown below:

o Select Ascending or Descending for each drop down list under Sort by , as required.

8. Click Next . The Query Wizard – Finish screen appears as shown below:

o Select the option Return Data to Microsoft Office Excel .

o Click Finish . The Import Data screen appears as shown below:

9. Click OK . The Microsoft Excel sheet with the imported data appears as shown below:

Similarly, any data can be extracted from Tally.ERP 9 by using the Microsoft Excel Query Wizard.

Extracting ledger master data to Microsoft Excel using ODBC

Back To Top
Select your currency
Indian rupee