SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I would like to know the best way to get data from a SQL view into a temporary SharePoint list from within SharePoint.

share|improve this question
up vote 4 down vote accepted

Which version of SharePoint.

If you're using SharePoint 2010, the easiest way is an external list with BCS through SharePoint Designer.


share|improve this answer
Thank you Paul. It seems though that external list behave a little bit differently in SPD than regular SP lists do. I could not get it to do inline editing, or create a group footer in the sorting a nd grouping box. Is there a way to keep a regular SP list and a SQL table in sync instead. Thanks again. – Anonymous Oct 28 '10 at 3:49

First you have to create an external list using SharePoint designer and then you can create sharepoint list out of the BCS List.

share|improve this answer

Couple of other options for a one-time load might be through integration with Excel / Access. First get the data into the office application from your SQL backend and then use Excel or Access to create the list within SharePoint.

There are some third party solutions available on CodePlex that will handle the sync. I believe SLAM will do what you're talking about:

share|improve this answer
Thank you Cory. – Anonymous Nov 2 '10 at 1:07

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.