Dynamically using openrowset through to more formally with Linked Server. Could even go to Office Automation procedures - but we won't go that far if not needed.

This is a collection of all the code that can be found on my YouTube channel Sigma Coding. - sigma_coding_youtube/t sql/Working With Excel Files.sql at master · areed1192/sigma_coding_youtube ...

SQL Server 2022 introduces the newest version of PolyBase, and with it the capability to query data where it lives, virtualize data, and use REST APIs.