>Hi all,
> I currently try to append a text file to my database by using append from command. My problem is I want to check to see is there any duplicate record by compare the person lastname and firstname from the text file with my database. However, I can't read the variable in the text file as a field!! Any ideas on how to read the fields in a text file which delimited by |.

Append to cursor and then seek for duplicate records over there.