Having data in an Excel file, or since it is 2020, an XLSX file. I need to enter this data into SQL Server in the manner described below:
ad hoc, the use case being feeding tables with test data, or infrequent data loads of small amounts of data (say < 3k rows), and
In a repeatable, robust, and possibly automated way for a production system.
Can someone please help me with this?