© The Author(s), under exclusive license to APress Media, LLC, part of Springer Nature 2021
R. C. L'EsteveThe Definitive Guide to Azure Data Engineeringhttps://doi.org/10.1007/978-1-4842-7182-7_14

14. Load Excel Sheets into Azure SQL Database Tables

Ron C. L’Esteve1  
(1)
Chicago, IL, USA
 

The need to load data from Excel spreadsheets into SQL databases has been a long-standing requirement for many organizations over the course of many years. Previously, tools such as VBA, SSIS, C#, and more have been used to perform this data ingestion orchestration process. Microsoft Azure’s Excel connector (https://docs.microsoft.com/en-us/azure/data-factory/format-excel) for Azure Data Factory (ADF) is a promising cloud-based connector that allows for an easy-to-use, ...

Get The Definitive Guide to Azure Data Engineering: Modern ELT, DevOps, and Analytics on the Azure Cloud Platform now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.