-- create the target table. This is done only once
create table _test02(RowID int, Repname varchar(10), Repcode int)
--import the data
BULK INSERT _test02
FROM 'c:\temp\data.csv'
WITH
(
FIELDTERMINATOR = ',',
ROWTERMINATOR = '\n'
)
--the quote field terminators in our test file were inconsistent, this fixes them
update _test02 set repname = replace(repname,char(34),'')
select * from _test02