take a look bcp
download bcp if you do not have it
csv file is as follows
id,name,job
1,"cardgunner","sql dev"
create table cardgunner(id int, name varchar(50), job varchar(50))
bcp dbo.cardgunner in C:\Users\cardgunner.csv
-S localhost -d sqlteam -c -T -t ","