Notifications
Clear all
ODBC in Tally
2
Posts
2
Users
0
Reactions
103
Views
Topic starter
22/05/2024 2:54 pm
Hi
i want to pull stock of a particular godown into an excel by running Sql query
Tally Version
25/05/2024 8:58 am
Hi Apurv,
SQL query can be performed when your source data is in SQL database. Tally don't store data into SQL, so you will need a programmer help to fetch Tally data in SQL first and then you can perform SQL query to get required results.
Instead, I suggest you to check for ODBC connectivity to retrive Tally data in Excel.
- To fetch Tally data in excel via ODBC, your Tally and Tally data has to be opened
- Use latest 64bit MS Office version for better Tally ODBC connectivity
- In excel go to Data Tab > Get Data > From Other Sources > From ODBC > Choose Data Source Name : TallyODBC in dropdown list
- Once connected, it will now populate the active company and all the tables
- Search and Choose the table from which you want to fetch the data
Regards,
Dhaval Goradia