• 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?