Question: how to export data from excel to sql server table?
Answer: Go to Start menu, search for SQL server and then click on SQL server 2016 Import and Export Data on your computer. ... 
Now, a dialogue box will open “Choose a Data Source”. ... 
Choose Destination.