Using ODBC , you can extract ledger data to Microsoft Excel and generate the required reports.

Illustration

National Traders wants to extract information from the ledger master, as shown below:

To extract ledger data to Microsoft Excel

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.

CALL US FOR ANY QUERY WE ARE GLAD TO HELP YOU OUT @9811782542 & 9911721597

Are You Looking For tally odbc 9000 not showing in excel
Are You Looking For how to enable odbc port in tally application
Are You Looking For tally odbc tables
Are You Looking For tally odbc 9000 driver download
Are You Looking For  data source name not found and no default driver specified tally
Are You Looking For tally odbc connection string
Are You Looking For how to export ledger address details from tally to excel
Are You Looking For how to export ledger details from tally to excel

see our latest products