Copy Data from Excel to SQL Server

Step 1: Create the table (say "tmp") in SQL server
Step 2: Select and copy the field in Excel
Step 3: Open the data table tmp in SQL management studio
Step 4: Click on the top left corner of the tab, (left to the names of the columns), hit Ctrl-V to paste the records or just right click on that tab and select paste.
Done: you can just exit out and it will save the data into the table:

This works if the data amount is not that big. Otherwise try bulk insert which is more convienent.