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.