I am using Tally9 Rel 2.13. How to export Trail Balance on particular date to Excel using Tally ODBC Connectivity. I have tried to export but it export data upto date. I know the recent version export any data to excel file format. But I wish to use ODBC Server to export data in a particular date. MS Query also fails to provide filtering for particular date ie. Trail Balance upto 15th Sep 2008.
11 September 2008
Earlier, I used only csv format as replied by you. I strictly tried to use ODBC only Kindly solve for me. If i use ODBC, once i opened tally9 along with that excel file that data fetched in excel will updated immediately. It will help to prepare final accounts with a single key in Excel Data-Get External Data - Refresh data.