Though, the Tally ODBC driver supports SQL SELECT queries, it currently does NOT support UPDATE or DELETE queries. Using Tally ODBC to Import Data from ExcelĪs of now, you cannot import data into Tally ERP using ODBC. The TDL code for this user defined collection is given underneath :- įetch : *, AllLedgerEntries.*, LedgerEntries.* Hence, we have used a user defined collection named RTSAllVouchers.
The CompanyVouchers collection in Tally exports data only for the current date. Export Sales data from Tally ERP Select $Date,$Reference,$VouchertypeName,$PartyLedgerName,$$CollectionField:$Amount:1:LedgerEntries from RTSAllVouchers where $$IsSales:$VoucherTypeNameĮxport Payment data from Tally ERP Select $Date,$Reference,$VouchertypeName,$PartyLedgerName,$$CollectionField:$Amount:1:LedgerEntries from RTSAllVouchers where $$IsPayment:$VoucherTypeNameĮxport Receipt entries from Tally ERP Select $Date,$Reference,$VouchertypeName,$PartyLedgerName,$$CollectionField:$Amount:1:LedgerEntries from RTSAllVouchers where $$IsReceipt:$VoucherTypeName Here are some SQL SELECT statements to retrieve data from Tally using ODBC. For example, you can fetch Date, Voucher Type, Voucher Number, Party Ledger etc, but you cannot retrieve all the ledgers for each voucher entry using the Tally ODBC interface. You can retrieve only the first level fields from Tally ERP.
EXPORT DATA FROM TALLY 7.2 TO EXCEL SOFTWARE
You can use SQL SELECT queries to export Tally data using Tally ODBC or the Calculator panel in Tally Software itself.
Tally ERP supports SQL (Structured Query Language). Using Tally ODBC to Export Data into Excel
0 kommentar(er)
