Tally 9 Help , Tally 9 Download, Tally 9

Ensure ODBC Server is displayed on Tally's calculator pane.

Open MS Excel.

Click on Data > Get External Data > New Database Query from the Menu.

Select TallyODBC from the Choose Data Source dialog box.

The screen appears as:

Query Wizard displays fields from Tally. Select and click the ">" button to select fields required in your query.

The screen appears as:

Use the Filter Data dialog box to limit the data to suit your requirement.

Sort your data in ascending or descending order in the Sort Order dialog box.

Click on Finish to complete the Query process.

Click on OK from the Returning External Data to Microsoft Excel dialog box to display the selected columns on the Excel sheet.

The screen appears as:

Labels: connect, Excel, odbc, Tally 9, Tally 9.0

# posted by Ashwin Kandoi @ Thursday, January 17, 2008