Question: how to import data from excel to existing table in sql server 2014?
Answer: Select the data in Excel and press Ctrl + C. In SQL Server Management Studio right click the table and choose Edit Top 200 Rows. Scroll to the bottom and select the entire empty row by clicking on the row header. Paste the data by pressing Ctrl + V.