Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

how to store data in Lists from SQL database

  Asked By: Melanie    Date: May 22    Category: Sharepoint    Views: 1482

guys plz help me out..how to store data in lists from SQL database



3 Answers Found

Answer #1    Answered By: Ian Davis     Answered On: May 22

i am not sure weather there is direct way or not , cos u can take item of list as gettable() method. n as a list has its own hidden filed , so dont think that there wuld be a direct way . may be webserive can help  u in this , u can user XML schema of sql  table n use it to populate data  in lists

Answer #2    Answered By: Jagjit Hui     Answered On: May 22

Another quick way could be open the SQL DB connection with EXCEL:


and then save that as excel. Then in Sharepoint you have an option to create a list from Excel sheet. This will be quick and dirty way.


Answer #3    Answered By: Alexia Mccarty     Answered On: May 22

Try to Use SSIS . Its an add in to Visual studio. You just have to drag and drop the connection. Its very easy and no codding is required.

Didn't find what you were looking for? Find more on how to store data in Lists from SQL database Or get search suggestion and latest updates.