Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.
Data can be kept in different media, Sometimes, the data need to be extracted, transformed or loaded in different ways.
For this article, I'm going to demonstrate some of the popular ways of importing Excel data into MS SQL Server.
After looking into a question at EE, a thought came to my mind that I considered would make a good article. "Transform Text copied from Excel Table into Real Table in SQL" as it is totally possible to do. Here's the result.