Sample code for you to play with. You will need to put the data into a text file, and be sure to modify the line where I have the code looking for the file to point to where you put it.
/*
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;