topic Re: How to Acesses TALLY ERP Data From SAS in SAS Data Management https://communities.sas.com/t5/SAS-Data-Management/How-to-Acesses-TALLY-ERP-Data-From-SAS/m-p/198270#M4352 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Thank you very much for reply.</P><P></P><P>Tally has options to connect with Microsoft query and get data into Microsoft Excel.</P><P></P><P>Every time if data is refreshed we had to open excel and&nbsp; refresh the data.Is there any option to automate data refresh from excel while reading into SAS.</P></BODY></HTML> Thu, 20 Aug 2015 07:19:01 GMT vivek_sas 2015-08-20T07:19:01Z How to Acesses TALLY ERP Data From SAS https://communities.sas.com/t5/SAS-Data-Management/How-to-Acesses-TALLY-ERP-Data-From-SAS/m-p/198268#M4350 <HTML><HEAD></HEAD><BODY><P>Hello all,</P><P></P><P>How to accesses tally data and create report in SAS </P></BODY></HTML> Thu, 13 Aug 2015 10:36:54 GMT https://communities.sas.com/t5/SAS-Data-Management/How-to-Acesses-TALLY-ERP-Data-From-SAS/m-p/198268#M4350 vivek_sas 2015-08-13T10:36:54Z Re: How to Acesses TALLY ERP Data From SAS https://communities.sas.com/t5/SAS-Data-Management/How-to-Acesses-TALLY-ERP-Data-From-SAS/m-p/198269#M4351 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I'm not familiar with Tally ERP but you have lots of options in SAS applications to get to external data: web services, XML, <A href="http://support.sas.com/documentation/onlinedoc/access/index.html">SAS/ACCESS</A> engines, ODBC, JDBC, flat file access, <A href="http://support.sas.com/documentation/onlinedoc/fedserver/index.html">virtualized queries</A>, 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.</P><P><BR />Ron</P></BODY></HTML> Mon, 17 Aug 2015 12:38:41 GMT https://communities.sas.com/t5/SAS-Data-Management/How-to-Acesses-TALLY-ERP-Data-From-SAS/m-p/198269#M4351 RonAgresta 2015-08-17T12:38:41Z Re: How to Acesses TALLY ERP Data From SAS https://communities.sas.com/t5/SAS-Data-Management/How-to-Acesses-TALLY-ERP-Data-From-SAS/m-p/198270#M4352 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Thank you very much for reply.</P><P></P><P>Tally has options to connect with Microsoft query and get data into Microsoft Excel.</P><P></P><P>Every time if data is refreshed we had to open excel and&nbsp; refresh the data.Is there any option to automate data refresh from excel while reading into SAS.</P></BODY></HTML> Thu, 20 Aug 2015 07:19:01 GMT https://communities.sas.com/t5/SAS-Data-Management/How-to-Acesses-TALLY-ERP-Data-From-SAS/m-p/198270#M4352 vivek_sas 2015-08-20T07:19:01Z