topic Re: Is there a way to read data from a Sharepoint List? in SAS Programming https://communities.sas.com/t5/SAS-Programming/Is-there-a-way-to-read-data-from-a-Sharepoint-List/m-p/171067#M264257 <HTML><HEAD></HEAD><BODY><P>Nothing documented for accessing SharePoint. </P><P>But excel does. Than if that is an odbc&nbsp; connection you could do that in the same way.</P><P>The mail-outlook list is also accessible in that approach.&nbsp; </P></BODY></HTML> Fri, 23 May 2014 16:59:19 GMT jakarman 2014-05-23T16:59:19Z Is there a way to read data from a Sharepoint List? https://communities.sas.com/t5/SAS-Programming/Is-there-a-way-to-read-data-from-a-Sharepoint-List/m-p/171066#M264256 <HTML><HEAD></HEAD><BODY><P>We collect data from the organisation with Sharepoint Lists. Now we are reporting in Excel and there is Excel a connection to the Sharepoint server. I want to use the Sharepoint data in SAS and want to read it with SAS/EG.</P><P>Does anybody know a (easy) way to build this?</P></BODY></HTML> Fri, 23 May 2014 12:07:51 GMT https://communities.sas.com/t5/SAS-Programming/Is-there-a-way-to-read-data-from-a-Sharepoint-List/m-p/171066#M264256 bendejong 2014-05-23T12:07:51Z Re: Is there a way to read data from a Sharepoint List? https://communities.sas.com/t5/SAS-Programming/Is-there-a-way-to-read-data-from-a-Sharepoint-List/m-p/171067#M264257 <HTML><HEAD></HEAD><BODY><P>Nothing documented for accessing SharePoint. </P><P>But excel does. Than if that is an odbc&nbsp; connection you could do that in the same way.</P><P>The mail-outlook list is also accessible in that approach.&nbsp; </P></BODY></HTML> Fri, 23 May 2014 16:59:19 GMT https://communities.sas.com/t5/SAS-Programming/Is-there-a-way-to-read-data-from-a-Sharepoint-List/m-p/171067#M264257 jakarman 2014-05-23T16:59:19Z Re: Is there a way to read data from a Sharepoint List? https://communities.sas.com/t5/SAS-Programming/Is-there-a-way-to-read-data-from-a-Sharepoint-List/m-p/171068#M264258 <HTML><HEAD></HEAD><BODY><P>In SharePoint you can export a List to Excel, which becomes a live link, if you tell it to update appropriately. </P><P>We then set up SAS to read this excel spreadsheet.</P><P>A bit roundabout but works fine. </P></BODY></HTML> Fri, 23 May 2014 17:21:16 GMT https://communities.sas.com/t5/SAS-Programming/Is-there-a-way-to-read-data-from-a-Sharepoint-List/m-p/171068#M264258 Reeza 2014-05-23T17:21:16Z Re: Is there a way to read data from a Sharepoint List? https://communities.sas.com/t5/SAS-Programming/Is-there-a-way-to-read-data-from-a-Sharepoint-List/m-p/171069#M264259 <HTML><HEAD></HEAD><BODY><P>I did some googling on "odbc connection sharepoint list", found a lot like:</P><P><A href="http://office.microsoft.com/en-us/sharepoint-designer-help/add-a-database-as-a-data-source-HA010355745.aspx" title="http://office.microsoft.com/en-us/sharepoint-designer-help/add-a-database-as-a-data-source-HA010355745.aspx"> Add a database as a data source - SharePoint Designer</A> (data from SQL to sharepoint,&nbsp; Microsoft)</P><P><A href="http://technet.microsoft.com/en-us/library/ee633650(v=sql.105).aspx" title="http://technet.microsoft.com/en-us/library/ee633650(v=sql.105).aspx">SharePoint List Connection Type (SSRS)</A> (data from sharepoint to SQL, Microsoft)</P><P><A href="https://www.connectionstrings.com/sharepoint/" title="https://www.connectionstrings.com/sharepoint/">SharePoint connection strings - ConnectionStrings.com</A> (connectionstrings)</P></BODY></HTML> Fri, 23 May 2014 21:22:37 GMT https://communities.sas.com/t5/SAS-Programming/Is-there-a-way-to-read-data-from-a-Sharepoint-List/m-p/171069#M264259 jakarman 2014-05-23T21:22:37Z Re: Is there a way to read data from a Sharepoint List? https://communities.sas.com/t5/SAS-Programming/Is-there-a-way-to-read-data-from-a-Sharepoint-List/m-p/171070#M264260 <HTML><HEAD></HEAD><BODY><P>Hi Reeza,</P><P>Your suggestion is coming close to the solution I am using now. I have made a connection with an Access database. In Acces you can import a Lists directly. When the lists are updatet in Sharepoint I don't need to open the database first, but I can collect the updatet data via my SAS/EG project.</P><P>This is not what I wanted, because I want to collect the data direct with SAS/EG from the Sharepoint List. It is now an extra step. </P></BODY></HTML> Fri, 30 May 2014 06:28:43 GMT https://communities.sas.com/t5/SAS-Programming/Is-there-a-way-to-read-data-from-a-Sharepoint-List/m-p/171070#M264260 bendejong 2014-05-30T06:28:43Z Re: Is there a way to read data from a Sharepoint List? https://communities.sas.com/t5/SAS-Programming/Is-there-a-way-to-read-data-from-a-Sharepoint-List/m-p/311824#M264261 <P>I found this&nbsp;<A href="http://www.sas.com/content/dam/SAS/en_ca/User%20Group%20Presentations/Winnipeg-User-Group/HarryDroogendyk-SharepointListData-Fall2012.pdf" target="_blank">http://www.sas.com/content/dam/SAS/en_ca/User%20Group%20Presentations/Winnipeg-User-Group/HarryDroogendyk-SharepointListData-Fall2012.pdf</A> talking about how to access sharepoint from SAS. I hope it helps.</P> Tue, 15 Nov 2016 19:08:00 GMT https://communities.sas.com/t5/SAS-Programming/Is-there-a-way-to-read-data-from-a-Sharepoint-List/m-p/311824#M264261 fkrimmelbein 2016-11-15T19:08:00Z Re: Is there a way to read data from a Sharepoint List? https://communities.sas.com/t5/SAS-Programming/Is-there-a-way-to-read-data-from-a-Sharepoint-List/m-p/445596#M264262 <P>Awesome, thanks that does help</P> Wed, 14 Mar 2018 19:15:13 GMT https://communities.sas.com/t5/SAS-Programming/Is-there-a-way-to-read-data-from-a-Sharepoint-List/m-p/445596#M264262 fkrimmelbein 2018-03-14T19:15:13Z