How to export Party Name's and Addresses from Tally to MS-Excel

Tally to MS-Excel

Query
"How do I export the Party Names and their addresses from Tally to MS-Excel ?"

Ans:
You can get the aforesaid details in Tally using UDIMagic Free Edition.

Steps :-
1) Download and install UDIMagic Free Edition from this link
http://download.cnet.com/UDI-Magic-Free-Edition/3000-2066_4-77717736.html

2) Use the following SELECT statement to retrieve Party Names and addresses.

Select $Name,$_Address1,$_Address2,$_Address3,$_Address4,$_Address5,
$StateName,$PinCode,$LedgerPhone,$Email,$ClosingBalance From LEDGER
where $$IsChildOf:$$GroupSundryDebtors

OR

Select $Name,$_Address1,$_Address2,$_Address3,$_Address4,$_Address5,
$StateName,$PinCode,$LedgerPhone,$Email,$ClosingBalance From LEDGER
where $$IsBelongsTo:$$GroupSundryDebtors

Remarks:-
The $$IsBelongsTo:$$GroupSundryDebtors function is used to retrieve Ledgers which fall directly under the group "Sundry Debtors" or sub-groups created under "Sundry Debtors"

udi-Magic v2.0 Release 1.04

Release 1.04 supports the following new features:-
- Transfer of data from Tally to Excel using SQL-SELECT statements
- Push or pull Tally data from a Remote Computer
- Use of XML tags to identify Masters data in MS-Excel

Transfer of data from Tally into Excel
(Pull data from Tally Software into Excel)


You can now easily get Tally data into MS-Excel using simple SQL-SELECT Statements like :-

Select $Name, $ClosingBalance from LEDGER

For more information of using SQL-SELECT statements, refer :-
http://www.rtslink.com

For more samples, visit http://www.rtslink.blogspot.com

You can download the udi-Magic v2.0 Release 1.04 from www.rtslink.com/udimagic.htm

Please see:
Support for writing SQL-SELECT statements to fetch data from Tally Software available to Registered users of udi-Magic.

Push or pull Tally data from a Remote Computer

udi-Magic v2.0 Release 1.04 allows you to access Tally data from a Remote Computer located in a different city or country.

a) You can pull (retrieve) Tally data from a Remote Computer

b) You can push (write) Excel data to Tally wherein the Tally Software is running on a Remote Computer.

All you need to do is specify the IP address of the Remote Computer and some Firewalls settings in the Remote Computer.

Please See:
Support to Access Tally data on Remote Computer is available to Registered users only.

Use of XML tags to identify Masters data in Excel

To begin with, let's have a look at how udi-Magic has evolved till now.

- In udi-Magic v1.0, Column-Headings were used to identify the Excel-sheet data.
- In udi-Magic v2.0 Release 1.03, a new concept to read Excel data using XML tags was introduced. However, this was restricted to Vouchers only.
- In udi-Magic v2.0 Release 1.04, XML tags are used to identify Masters as well as Voucher data in Excel-sheet.