Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Export SQL data to SharePoint List?

Posted on 2009-07-08
2
Medium Priority
?
844 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 11

Expert Comment

by:Craig Yellick
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

Tech or Treat!

Submit an article about your scariest tech experience—and the solution—and you’ll be automatically entered to win one of 4 fantastic tech gadgets.

Question has a verified solution.

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

Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
Windocks is an independent port of Docker's open source to Windows.   This article introduces the use of SQL Server in containers, with integrated support of SQL Server database cloning.
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
Via a live example, show how to shrink a transaction log file down to a reasonable size.

618 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