Is there a way to read data from a Sharepoint List?

Reply
New Contributor
Posts: 2

Is there a way to read data from a Sharepoint List?

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.

Does anybody know a (easy) way to build this?

Valued Guide
Posts: 3,208

Re: Is there a way to read data from a Sharepoint List?

Nothing documented for accessing SharePoint.

But excel does. Than if that is an odbc  connection you could do that in the same way.

The mail-outlook list is also accessible in that approach. 

---->-- ja karman --<-----
Super User
Posts: 17,907

Re: Is there a way to read data from a Sharepoint List?

In SharePoint you can export a List to Excel, which becomes a live link, if you tell it to update appropriately.

We then set up SAS to read this excel spreadsheet.

A bit roundabout but works fine.

New Contributor
Posts: 2

Re: Is there a way to read data from a Sharepoint List?

Hi Reeza,

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.

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.

Valued Guide
Posts: 3,208

Re: Is there a way to read data from a Sharepoint List?

I did some googling on "odbc connection sharepoint list", found a lot like:

Add a database as a data source - SharePoint Designer (data from SQL to sharepoint,  Microsoft)

SharePoint List Connection Type (SSRS) (data from sharepoint to SQL, Microsoft)

SharePoint connection strings - ConnectionStrings.com (connectionstrings)

---->-- ja karman --<-----
Occasional Learner
Posts: 1

Re: Is there a way to read data from a Sharepoint List?

I found this http://www.sas.com/content/dam/SAS/en_ca/User%20Group%20Presentations/Winnipeg-User-Group/HarryDroog... talking about how to access sharepoint from SAS. I hope it helps.

Ask a Question
Discussion stats
  • 5 replies
  • 4472 views
  • 0 likes
  • 4 in conversation