Multiple Excels in a Sharepoint as data origin for mySQL server in Azure Data Studio

Ruiz-Ramis Joan 1 Reputation point
2021-11-16T15:50:27.69+00:00

Hi,

I have a Sharepoint with Excels with information from our workers, every worker has a copy of that same file with their name.

I'd need to automatize something to grab all those excels into one big mySQL database, how can i create a connection between Excel files in SharePoint and the server in Azure Data Studio os it updates every once in a while and it doesnt disturb the users using the Excel?

Thanks,

Azure Database for MySQL
Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
714 questions
SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
9,680 questions
Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,643 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. CaseyYang-MSFT 10,321 Reputation points
    2021-11-17T02:35:10.86+00:00

    Hi @Ruiz-Ramis Joan ,

    Here is a article from Microsoft, You could copy file from SharePoint Online by using Web activity to authenticate and grab access token from SPO, then passing to subsequent Copy activity to copy data with HTTP connector as source.

    For Reference: Copy data from SharePoint Online List by using Azure Data Factory or Azure Synapse Analytics

    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.