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.
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.
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.
@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.
@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
9 people are following this question.