Import your data from Excel To Tally in Easiest & Fastest way.

Request Demo

Warning: Undefined variable $_post in /home/u699885411/domains/fastinflow.com/public_html/wp-content/themes/fastinflow/template-parts/content-page.php on line 17

Warning: Attempt to read property "ID" on null in /home/u699885411/domains/fastinflow.com/public_html/wp-content/themes/fastinflow/template-parts/content-page.php on line 17
Tally ODBC with Microsoft Excel

Tally ODBC with Microsoft Excel

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

  • Enable ODBC in Tally
  • 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.
005OutwardODBC

The Query Wizard shows Tally fields. To choose the fields that must be selected for your query, click the “>” button.

004OutwardODBC

You can restrict the data using the Filter Data dialogue box to meet your needs.
In the Sort Order dialogue box, arrange your data in either ascending or descending order.
To finish the Query procedure, click Finish.

To display the chosen columns on the Excel sheet, click OK in the dialogue box that appears after returning external data to Microsoft Excel.

006OutwardODBC

Get Excel to Tally Software

Whatsapp