Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

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

3 Answers 3

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.

http://msdn.microsoft.com/en-us/library/ee557243.aspx

Paul.

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.

http://msdn.microsoft.com/en-us/library/ee559346.aspx

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

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

Your Answer

 
discard

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