There is on convenient way to do this T-SQL. It can be done, but as I said, it is not convenient. Rather you would write a program/script that scans the folder and then writes to the database. I guess it also can be done with SSIS, but I don't know SSIS myself.
I happen to have an old example in VB .NET on how to load a single file into the database on my web site: https://www.sommarskog.se/blobload.txt.
Oh, there is something in SQL Server known as a FileTable. With such a table, you can just drag the files into the database through Explorer. But whether that fits the current design of the database, I don't know.