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;