/*
Sample data from file CustInfo.txt:
1,"John","Smith","Washington"
2,"Nick","Smith","London"
3,"blabla","blabla","blaa"
*/

create table dbo.TestTable (
    MemberID int,
    FirstName varchar(30),
    LastName varchar(30),
    City varchar(30)
);

bulk insert dbo.TestTable
from 'C:\Databases\ImportData\CustInfo.txt'
with (
    codepage = 'RAW',
    datafiletype = 'char',
    fieldterminator = ',',
    rowterminator = ''
);

update dbo.TestTable set
    FirstName = replace(FirstName,'"',''),
    LastName = replace(LastName,'"',''),
    City = replace(City,'"','');

select
    *
from
    dbo.TestTable;

drop table dbo.TestTable;