Forum Discussion
Masoud1313
Apr 02, 2019Brass Contributor
Import sql server to Sharepoint as a list or linking from lists to sql server tables
I am new to SharePoint. The one of questions that I have is when I have a SQL database, for using tables of SQL server in SharePoint I should to import them in SharePoint as a list, or is not ne...
- Apr 02, 2019
Masoud1313 We can integrate SQL data with SharePoint. Here solution depends upon the requirement. If database is containing large amount of data in tables or any other application is connected with this database then in this case it is best to use SharePoint BCS service. For small amount of data we can export in csv then try to import in SharePoint list.
shobhitbhalla
Apr 02, 2019Brass Contributor
Masoud1313 We can integrate SQL data with SharePoint. Here solution depends upon the requirement. If database is containing large amount of data in tables or any other application is connected with this database then in this case it is best to use SharePoint BCS service. For small amount of data we can export in csv then try to import in SharePoint list.
Apr 02, 2019
BCS Services is the option here for SharePoint Server