How To Load a Table in MSSQL 2008 R2?

-----------------------------------------------------------------
1. In SQL Server Management Studio, connect to the Database Engine server type, expand Databases, right-click a database, point to Tasks, and then click Import Data or Export data.
2. In Data Source, click arrow choose "Flat File Source" and select your source text file. Next->
(hint: name the source text file as your table name)
3. Choose your file, format "Delimited". Next-> 
4. Leave the rest as default, click on Next-> a couple of times
5. Finish
-------------------------------------------------------------
Please experiment with different options.

If you want to change certain table design, un-check this option:
Hint: Tools -> Options -> Prevent saving changes that require table-recreation