pinocausini.com

Learn ODBC features during Tally ERP 9 Training

by

Tipase

Tally ODBC

On installing TallyODBC driver, you get connected to Tally Data through the ODBC driver and then plug to other ODBC compliant software like Word, Excel, Oracle, Fox pro, SQL, Visual Basic, DB2, and make Tally Data available to the external application through the ODBC pipeline. You get data from on-line. So, you do not need to export/import data. Rather, you connect to the tally Data base through ODBC, read data on-line.

Embedding through ODBC

Now, we explain how to embed on line through ODBC into an ODBC compliant application.

In Tally, select only one company (shut all other selected Companies). During Tally ODBC connection, only one company should remain selected.

We now demonstrate 2 real-life applications with stepwise details. One with Word and another with MS Excel.

Connecting into MS Word Document

Now run MS Word in which you wish to create document and plug.

We give below the basic steps of plugging into MS Word Document to illustrate the ODBC connectivity. The actual steps may slightly vary in different versions of Windows & Ms Word. However, the concept remains same.

Open a New document in Word

Select Tools>Mail Merge.

At Step 1 (Main Document), click the small arrow on Create button and select catalog

At Step 2 ( Source) click the small arrow on Get button and select Create Source

At the Create Source dialog box, Click MS Query button that would display Choose ODBC and click OK button

You will get a list of Tables > Select the Tables & columns which you wish to include in your output.

Next you get Query Wizard with Filter options where you can give your filtering condition (e.g. $Parent contain Fixed Assets )

In Next screen select the columns on which to be sorted

Select Return Data to Microsoft Word and Click on Finish button

Select the fields to be included in the report

Click on Mail Merge

In order to learn the ERP accounting software many institute offers various computer accounting diploma and certificate courses, these job oriented courses can help students to find better job and employment, hence having good command over accounting software like Tally ERP could always ensure a bright future In order to learn the ERP accounting software many institute offers various computer accounting diploma and certificate courses, these job oriented courses can help students to find better job and employment, hence having good command over accounting software like Tally ERP could always ensure a bright future

There are many Institutes which are authorized Tally Academy offering Training and courses both long term and short term to learn service tax matters in ERP 9 and Diploma in Taxation

Author is working with IPA offering

Tally Course

and

Accountancy Courses

. They also offering

Diploma courses after 12th commerce stream

.

Article Source:

ArticleRich.com