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