Let me know if this helps..
CSV FILE : Test.csv
Then in the SSMS :
create table #test(a int,b varchar)
BULK INSERT #test1
ROWTERMINATOR =' ',
FIRSTROW = 2
Edit :ROWTERMINATOR = '\ n'
This is one way to load from csv file to a table ...
FIRSTROW is a check to filter out loading headers..
Wondering what I would do next , when I am done with this one