Solved

Export SQL data to SharePoint List?

Posted on 2009-07-08
2
835 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

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

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

Having an SQL database can be a big investment for a small company. Hardware, setup and of course, the price of software all add up to a big bill that some companies may not be able to absorb.  Luckily, there is a free version SQL Express, but does …
Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
Via a live example, show how to shrink a transaction log file down to a reasonable size.

726 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