Question: how to import data from excel to sql table using query?
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.