Did you know you can easily copy and paste data from Excel directly into SQL 2005/2008? Why bother messing around with SSIS or (perish the thought) DTS with Excel sheets when you can just select, copy, and then paste your way to greatness???

Check it out:

In Excel: Highlight the data and hit Ctrl-C to copy that data into the buffer

Excel 1

Then, in SQL Management studio right click the destination table and select open

Now, click on the top left corner most tab to select the data and hit Ctrl-V to paste the records or just right click on that tab and select paste

And it will paste the data from the buffer into the table. Once done, you can just exit out and it will save the data into the table

And you’re set!

Thanks to decipher for this trick!

Steve Lugovsky signing out