Extracting ledger master data to Microsoft Excel using ODBC
To extract information from the ledger master to Excel, such as shown below: To extract ledger data to Microsoft Excel A. First click here to Enable ODBC in Tally 1. Open Microsoft Excel on your computer. 2. Click Data > Get External Data > From Other Sources > From Microsoft Query , as shown below: 3. Select TallyODBC64_9000* , as ODBC is enabled on the…