question

Mangesh12145-6689 avatar image
0 Votes"
Mangesh12145-6689 asked SaurabhSharma-msft commented

How to load excel file data into Azure Synapse?

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
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.

1 Answer

pradeep-srikakolapu avatar image
0 Votes"
pradeep-srikakolapu answered SaurabhSharma-msft commented

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.

· 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.

@mangesh12145-6689 Please let me know if you find above reply useful. If yes, do click on 'Mark as answer' link in above reply. This will help other community members facing similar query to refer to this solution. Thanks.

0 Votes 0 ·

@mangesh12145-6689, We haven't heard back from you. Just wanted to check if you are you still facing the issue? In case If you already found a solution, would you please share it here with the community? Otherwise, let us know and we will continue to engage with you on the issue.

Thanks
Saurabh

0 Votes 0 ·