Import Bulk Data into SQL Table From CSV File or TSV File

Create Table tbl_CSVTSVTest
(
id int, name varchar(20), city varchar(20)
)

bulk
insert tbl_CSVTSVTest
from 'd:\testcsv.txt'
with
(
FieldTerminator = ',', -- for tsv file use FieldTerminator = '    '
RowTerminator = '\n'
)
go



select * from tbl_CSVTSVTest