How can I import data from Excel into MS SQL Express 2008?

Question

PHP

Good day everyone. Prompt:
There is a frequent need to import data from Excell to MS SQL Express 2008 R2.
Now this is done by separately downloaded Import And Export Wizard (it seems so) into a temporary table, from where then I then do Insert into .... select .... and so on - I match the columns in general.
There is a desire - to hang it on the users themselves. But at the same time, implement some kind of check, and prevent them from accessing the database itself, so that they don’t delete too much.
In other words, a tool, a language, a framework, a library on which to organize:

• connection
  
• data validation
  
• import
  

I myself scripted a little on PHP, but in principle something like this would do, it is desirable to exclude VS, of course, since I did not work with it, but if there are no options, then I'm ready to study.
Please note that it is MS SQL Express 2008 R2 that is used, there is no possibility to upgrade due to the software that uses it.
UPD1: The question is not how to connect to MS SQL, although this is also necessary, the question is wider - WHAT tool to use for validation and data import so that it can connect to MS SQL?
Can language: GO, PHP, PowerShell.....

Answer 1

Make a database in Excel. Using Excel as an ODBC database .
Connect as a linked server.