ok i have one table with MemberID, Name, Surname and City and information for inserted on this table and i have on text file for example 1001, John, Smith, Washington another member is 1002, Nick, Dagle, London etc etc. I request to insert at the same time on this table.

for example

INSERT INTO TblMember

(MemberID, Name, Surname, City)

VALUES (1001,John,Smith,Washington;

1002, Nick, Smith, London

1003,....,.....,.....)

I hope you know what I think now

thanks