Using ODBC , you can extract ledger data to Microsoft Excel and generate the required reports.
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.