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, ...
© 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_1414. Load Excel Sheets into Azure SQL Database Tables
Ron C. L’Esteve1
(1)
Chicago, IL, USA
Get The Definitive Guide to Azure Data Engineering: Modern ELT, DevOps, and Analytics on the Azure Cloud Platform now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
