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

Question

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

Answer 1

Hi @Hemant ,

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.

Answer 2

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://learn.microsoft.com/en-us/azure/azure-sql/database/connect-excel

-------------------------------------------------------------------------------------------------------------------------------------------------------------------------

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