If you have SQL Server Management Studio, you can just Copy from Excel and Paste into the table in Management Studio, using your mouse. Just
- Go to the table you want to paste into.
- Select “Edit Top 200 Rows”.
- Right-click anywhere and select Paste.
Before you do this, you must match the columns between Excel and Management Studio. Also, you must place any non-editable columns last (right-most) using the Table Designer in Management Studio.
The whole procedure takes seconds (to set-up and start – not necessarily to execute) and doesn’t require any SQL statements.
Regarding empty database tables and SSMS v18.1+.