Import CSV using SSMS tools

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

See also

• Import CSV file to a Database, quickly
• Csv To Html function in SQL
• Split string in SQL Server
• Aggregate table strings into one csv value (with SQL Server) - i.e. concatenate strings in SQL Server