08-17-2015 08:38 AM
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.
08-20-2015 03:19 AM
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.