When answering questions on forums or blogs, I often like to put the data into SQL Server where I can make sure my SQL works before I answer a question.
As you can imagine, I don’t want to spend a lot of time importing that data.
So, here is a little trick that you can use to copy and paste and HTML table into a SQL table without having to write insert statements or use the Import/Export wizard.
Video: SQL Server Import Data with Copy and Paste
How to Import Web Data into SQL Server with a simple copy and paste. No special import and export tools needed.Youtube Video Location: Import HTML Table Data To SQL Server with Copy Paste
Here are a few other posts you might enjoy:
SQL Microsoft Excel to Windows Azure SQL in 10 minutes | Troubleshooting a SQL Join | How to Remove Duplicate Rows in SQL Server
You can visit me at any of the following:
SQL Training Online: http://www.sqltrainingonline.com
Twitter: http://www.twitter.com/sql_by_joey
Google+: https://plus.google.com/#100925239624117719658/posts
LinkedIn: http://www.linkedin.com/in/joeyblue
Facebook: http://www.facebook.com/sqltrainingonline
Tags: Import, SQL, SQL Import, SQL Server 2012, SSMS
I'm 
Leave A Reply (3 comments so far)
SK
117 days ago
Its really cool. I was not aware if this.
Thomas
116 days ago
Really nice, good way to copy paste excel as well
Joey Blue
116 days ago
Good point! You can use this trick from Excel to SQL Server also.