Feb 6, 2009

Tally ODBC with Microsoft Excel

Tally ODBC extracts data from Tally and designs the reports in MS Excel. The steps to be followed are:

Start Tally and keep it open till the Mail Merge process is completed.

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:

 

 

 

 

4 comments:

Alexis said...

In this sphere there is one of the best tools,which works with excel files and has free as far as I know-Excel recognizable format,it helped for me,and program will allow to avoid such error messages, like: xlsx this file is not in a recognizable format, xlsx file is not in a recognizable format or even this file is not in a recognizable version for Excel,help you to get rid of such messages: this file is not in a recognizable format Microsoft Excel, Microsoft Excel recognizable format and Microsoft Excel file is not in recognizable format,also tool will allow you to recover your files in Microsoft Excel format and avoid errors like: this file is not in a recognizable format xlsx, this file is not in a recognizable format xlsm, Microsoft Excel the file is not in a recognizable format, Microsoft Excel XP the file is not in recognizable format or even Excel file not in a recognizable format recovery.

Alex said...

In the world there are few program which successefully works with with mails,but I know not bad tool which to my mind can do it-may be corrupted Excel,I found it in internet and program has free status in fact,beides that utility protect your data against possible damage due to a variety of reasons, from virus or hacker attack to hardware damage,will help to recover all data and repair Excel infected files, that are considered lost and save many days of your precious time for retyping all documents,export the results into a new document in Microsoft Excel format,repair your MS Excel damage file, when you need to repair Excel file.

Anonymous said...

Last time when I edited my working table in MS Excel,this file was corrupted.And I was worried.But after that my uncle said me about his like condition,and advised-xls file repair software.As he said tool is free and helped him very good.To my surprise utility helped me too and it can as well recover worksheets in Microsoft Excel format.

Naresh said...

I have tried to do this and for my tally version 1.51 with Office 2007 i get an error. As soon as i connect to tally i get an error and Tally gets closed. What could be the issue ?