question

HemantkumarPrajapatiMINDTREELIMITE-1011 avatar image
0 Votes"
HemantkumarPrajapatiMINDTREELIMITE-1011 asked AllenXu-MSFT commented

How to load SQL Server table from SharePoint Excel file with MFA

Hi Team,

I am trying to create PowerShell script which source the data from SharePoint Excel file (MFA Authentication) and load it to SQL Server table.

Regards

windows-server-powershellsharepoint-dev
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

AllenXu-MSFT avatar image
1 Vote"
AllenXu-MSFT answered AllenXu-MSFT commented

Hi @HemantkumarPrajapatiMINDTREELIMITE-1011 ,

As per my knowledge, we can only import data from Excel stored on your computer locally or from a SharePoint list to SQL Server. I'm afraid importing excel files directly into SQL Server is not supported. You have to download the Excel file to your local computer or export the Excel file to a SharePoint list, and then load it to the SQL Server table.

Reference:
Load data directly in SQL Server from a xlsx file, without OLEDB or Excel, using Powershell
How To Insert SharePoint List Item To MS SQL Server Using PowerShell

Note: Microsoft is providing this information as a convenience to you. The sites are not controlled by Microsoft. Microsoft cannot make any representations regarding the quality, safety, or suitability of any software or information found there. Please make sure that you completely understand the risk before retrieving any suggestions from the above link.


If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Once I have SharePoint list to SQL Server, how to use specific Excel file to load to SQL Server.

0 Votes 0 ·
AllenXu-MSFT avatar image AllenXu-MSFT HemantkumarPrajapatiMINDTREELIMITE-1011 ·

@HemantkumarPrajapatiMINDTREELIMITE-1011 ,

we can only import data from Excel stored on your computer locally or from a SharePoint list to SQL Server.

We cannot import Excel files stored in a SharePoint library directly into SQL Server.



1 Vote 1 ·
LimitlessTechnology-2700 avatar image
0 Votes"
LimitlessTechnology-2700 answered

Hi there,

You can connect Excel to a database and then import data and create tables and charts based on values in the database. You can set up the connection between Excel and a database table, save the file that stores data and the connection information for Excel, and then create a pivot chart from the database values.

Connect Excel to a database in Azure SQL Database or Azure SQL Managed Instance, and create a report https://docs.microsoft.com/en-us/azure/azure-sql/database/connect-excel



-If the reply is helpful, please Upvote and Accept it as an answer--

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.