Question: how to export data from tally to excel using odbc?
Answer: Open Microsoft Excel on your computer.
Click Data > Get External Data > From Other Sources > From Microsoft Query , as shown below:
Select TallyODBC64_9000* , as ODBC is enabled on the server 9000.
Click OK . ... 
Click Ledger and expand the list to select the required fields.
Click Next . ... 
Click Next .