SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have to migrate some legacy data from stand-alone sql server database to sharepoint list.

I'm going to use programmatic approach and write a code that communicates with sharepoint list asmx web service.

Are there some "data transformation wizards" to simplify such a task or a better approach to port legacy data from sql server database to sharepoint list?

Thank you in advance!

share|improve this question

I haven't seen anything to do this specifically. Writing the code for the inserts using the list web service is pretty quick and easy though. You shouldn't be looking at more than a few dozen lines of code tops.

share|improve this answer
Thank you, Mike! I was advised also to put an eye on Office 2010 capabilities. It has Sharepoint export with some limitations – Andrew Florko Oct 16 '10 at 8:31
If you want to use MS Office, you can use Access to import data to SharePoint. If you have linked tables from SQL that may make it pretty easy. Here are some instructions.… – Mike Oryszak Oct 16 '10 at 13:52

Your Answer


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

Not the answer you're looking for? Browse other questions tagged or ask your own question.