I use SQL Server Management Studio 2012 to import data from Excel sheet to a table on SQL Server. I use the most straightforward way that I just Ctrl+C a table in Excel and Ctrl+V in table edit window in SSMS. I know that many other ways faster exist to import data. But this is most simple without a need to write any code.
But it takes 300 rows with 5 columns about 5 minutes. Is there any way how to speed it up without using completely different way that would require copying CSV on server or writing a script? Why does it take so long?