How to Acesses TALLY ERP Data From SAS

[vivek_sas]

Hello all,

How to accesses tally data and create report in SAS

[RonAgresta]

Hi,

I'm not familiar with Tally ERP but you have lots of options in SAS applications to get to external data: web services, XML, SAS/ACCESS engines, ODBC, JDBC, flat file access, virtualized queries, and several others. Take a look at your product documentation to see what means of data access are available for the SAS components you are using. If you post some additional details about your environment, I or others may be able to provide more specific guidance.

Ron

[vivek_sas]

Hi,

Thank you very much for reply.

Tally has options to connect with Microsoft query and get data into Microsoft Excel.

Every time if data is refreshed we had to open excel and  refresh the data.Is there any option to automate data refresh from excel while reading into SAS.