Question: how to import and export data from excel to sql server?
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.