Nardig (6/30/2009)
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
You want to import a text file into a table? Each row of the text file contains a record with MemberId, FirstName, LastName, City?
What is the delimiter between columns? Rows? Are the string values delimited and if so with what, double quotes?