Question: how do you import data from excel to sql server in existing table?
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.