CODEWITHSUNDEEP
c#sql-server-2008sharepoint-2010
Eshwer
Eshwer

Reputation: 153

What is the best way to import SQL table data in SharePoint 2010 list?

I have a SQL server table with data. And I want to import this data in SharePoint 2010 list.

What will be the best to import this data into my SharePoint 2010 list?.

That should be useful during the deployment into the production which can be use by my client easily.

Please suggest me the different ways and how to do that.

Upvotes: 1

Views: 6978

Answers (2)

Hemanth Kumar H
Hemanth Kumar H

Reputation: 1

Below steps worked for me :

  1. Export sql server table as excel.
  2. Create a sharepoint list view keeping the columns order same as excel.
  3. Copy the rows into datsheet view and save..

Upvotes: 0

Steve Mannina
Steve Mannina

Reputation: 475

  1. SQL Server Integration Services http://msdn.microsoft.com/en-us/library/hh368261.aspx
  2. Write a program to read the SQL Server tables and write to SharePoint using one of the object models, for example, a C# program that uses the SharePoint server object model to write to the list.

If you export your SQL Server table to Execl, then you have these additional options:

  1. Import from Excel: In SharePoint: Create, List, Import SpreadSheet.
  2. Export from Excel: http://office.microsoft.com/en-us/excel-help/export-an-excel-table-to-a-sharepoint-list-HA010131472.aspx
  3. Paste from Excel into Datasheet view of existing SharePoint list: copy rows in Excel; switch to SharePoint to a datasheet view (with at least the mandatory fields); order the datasheet the same as your Excel columns; and then righ-click the first cell and select Paste.

Upvotes: 1

Related Questions