Import CSV using SSMS tools

Right click on the database, select 'tasks' and 'import flat file...'

See also