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.
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: /
Twitter: http://www.twitter.com/sql_by_joey
Google+:
LinkedIn: http://www.linkedin.com/in/joeyblue