Question: how to import master data from tally to excel?
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 .