从ShatePoint文件夹中读取Excel文件并加载到DataBase中 [英] Read Excel Files from ShatePoint folder and load Into DataBase

问题描述

大家好，

我需要从SharePoint文件夹中读取文件（而不是从列表中读取）并将其加载到数据库中。

I need to read the files from SharePoint folder (not from the list) and load that into Data Base.

如果有解决方法，我们可以使用C＃将这些文件下载到本地计算机。

If there is a workaround we can download those files into local machine using C#.

谢谢

Pankaj

推荐答案

您好Pankaj，

Hi Pankaj,

将数据转化为SQL的最有效方式服务器是通过SQL Server Integration Services（因此转发称为SSIS）。 

The most efficient and effective manner of getting our data into SQL Server is via SQL Server Integration Services (hence forward referred to as SSIS). 

有关如何创建SSIS包以从中提取数据的更多信息，请参阅以下文章。位于SharePoint服务器上的Excel电子表格，并将其放在SQL Server表中。

You can refer to below article for more information about how to create a SSIS package to pull data from an Excel spreadsheet located on a SharePoint server and have it placed in a SQL Server table.

https://www.sqlshack.com/share-data-loading-sql-data-sharepoint/

祝你好运，

Allen Bai

Allen Bai

这篇关于从ShatePoint文件夹中读取Excel文件并加载到DataBase中的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！