Search code examples
excelodbctally

Extracting data from Tally using ODBC to Excel

As mentioned in many help files, I need to open excel then get external data "From Other Sources" and select "From Microsoft Query".

In the list I should see "TallyODBC_9000" or a variation of this. But I don't see this. I have checked everything including ensuring that the server is running. I have also tried to add an ODBC server unsuccessfully.

Any help in connecting to Tally ODBC from Excel will be much appreciated.

I am using - Tally 6.4.8 & Excel 2016

Solution

  • The best way i could finally find to export data to excel format was to use the inbuilt sql query in tally.