#20. Azure Data Factory - Load from .XLSX file to Azure SQL table

In ADF, previously there was no support for .xlsx files. But recently they have introduced this option. This video explains how to read records from a sheet in .xlsx file and load it to a Azure SQL table.

[panxostyle]

Awesome, Thank you very much!!!!, just one question.... can we add from an excel in onedrive?

[sathyar]

All your videos are very useful and providing great information . Thank you very much

[ashutoshsharma]

hello mam … thanks for the knowledge … Great teaching . explained in so simple way

Question : my excel file is too big and it is not working

[rajugrg]

Ma'am how to loop throw all data sheets of Excel file, if all the sheets are having same columns, order of the columns also same

[yenikepallisivanageswarara]

As we have seen when ever you are trying to connect to SQL serve, you are keep on adding IP address to Firewall, Is there a way to make it dynamic(I'm assuming it's a dynamic IP config) or is it an Azure admin task?

[itversityitversity]

I want to load XML file into MS Fabric ? Any idea?

[diegod]

Hi ! What happens if the Excel file is open/in use at the time the pipeline is running? will it fail? Is there some way to avoid the failure? Thanks!!!

[ambikaprasadswain]

Nice explanation. Good job.

I have one issue right now to read my csv file from azure storage from storage.

Requirement: I have a simple SSIS package which will read a csv file from azure storage and insert data to sql database table.
For this I am using Flexible File Source to read the csv file. And here I am unable to read the csv file.

Any insight will be helpful.

Or apart from Flexible File Source any other tool will be helpful for this scenario?

Thanks in advance!

[ashutoshnayak]

How to do data transform in azure data factory and then load into SQL database?

[christofhermdelgado]

Hey, what if you add more rows to the excel file? is there a way you can automate that update?

[renukanidadavolu]

Hi i am recently learning azure pipeline
And in pipeline i am trying one task
In excel sheet emp details are there the sheet is placed on storage using pipeline i need to filter one location of emp and copy into another folder of storage
Can you help me on this
I created metadata and filter but copy was failing

[dorgeswati]

thank you for awesome videos. one question here - are we adding firewall IPs because azure sql server database we created is not under same subscription? or am i missing something here?

[awesomeaaryan]

I want to migrate data from XML(Complex type) to Azure Database using ADF. However I am stuck with Parent-Child relationship issue of the Sink(Destination) Database. How can I implement the same.

[subhashkomy]

You should use existing table scenario as well. Becuase If Existing table has Different Data Type then how can you change in Pipeline

[dorothycheng]

I m getting error like this:
ErrorCode=InvalidParameter, Type=MicrosoftDataTransfer.Common.Shared.HybridDeliveryException, Message=The value if property '' is invald: 'Cell index must be >=0, Souce=, "Type=System.ArgumentException, Message=Cell index must be>=0, Souce=NPOI.OOXML'

[sanjaychaudhari]

Amazing. Tried, worked like a charm! Thank you.

[isaacwilliams]

Can somebody please explain how the file/folder got there? I am confused

[asmithare]

How to copy multiple sheets from xlsx to sql db?

[kishorekumar]

Can you please let me know how to extract data from on premise excel instead of Azure blob storage. Please make a video on the same.

[entertainment]

Hi, please make video on upload and download different format excel files to azure blob storage using coding in nodejs server side