How to load excel file data into Azure Synapse?

Mangesh12145 6 Reputation points
2021-08-18T09:52:37.733+00:00

Hello All,

I have an excel file with data and with 2 sheets. I want to load excel file sheet data into the Synapse table. Please suggest a simple approach.

Many Thanks
Mangesh B.

Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
4,462 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Pradeep SVS 1 Reputation point Microsoft Employee
    2021-08-18T18:07:32.43+00:00

    You can azure data factory to load data from an excel file into azure synapse. You can automate the copy as well. If you are using azure synapse analytics, you can use synapse pipelines instead of azure data factory to load excel file into sql pool.

    Where is the excel file located?
    If the excel file is on your machine, you can setup SHIR to load the contents of excel file into azure synapse sql pool using copy activity in ADF. if the excel file is in storage account, you need to setup the linked service pointing the storage account and then you can do the rest.