Solved

Export SQL data to SharePoint List?

Posted on 2009-07-08
2
834 Views
Last Modified: 2013-11-10
Any way to do it?

And I mean actually putting the data into a list - no grid viewers, etc.
0
Comment
Question by:warrenrapson
2 Comments
 
LVL 11

Expert Comment

by:CraigYellick
ID: 24826146
SharePoint offers an API available through a web service, so in principle almost anything SharePoint can do, can be done through web service calls. However, it is a complex programming environment with tricky security.

A SharePoint list is very similar to a table in a database, so there is a direct correlation between lists and SQL Server data.

http://blog.the-dargans.co.uk/2007/04/programmatically-adding-items-to.html

-- Craig
0
 

Accepted Solution

by:
warrenrapson earned 0 total points
ID: 25400381
Check out the code snippet on this page: http://vspug.com/forums/topic/18886

I can't get it to work in a cursor though...
0

Featured Post

Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Introduction In my previous article (http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SSIS/A_9150-Loading-XML-Using-SSIS.html) I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

856 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question