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

3 Answers 3


Which version of SharePoint.

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



  • 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
    Commented Oct 28, 2010 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.



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: http://slam.codeplex.com/