Hi @Aypn CNN ,
You may use SSIS to import the data to table.
And then you may use sql agent job to run the package so that it could be an automated operation.
ssis-how-to-get-most-recent-file-from.html
sql-server-agent-jobs-for-packages
Regards,
Zoe Hui
If the answer is helpful, please click "Accept Answer" and upvote it.