Another option (and another shudder :-)) if you don't mind waiting and have a sandbox type database it to:

Creating a staging table for the data.

Selecting the 'Edit top 200 rows' option in the SMSS drop down menu.

Copy the data in Excel and paste into the edit grid.

Beware this is slow and I only do it for ad hoc data where I have no more than a couple of thousand or so rows. It does generally get the data in there with minimal fuss.