Duplicate Records: How do you trap for a duplicate record when importing data from a .txt file and saving it to a SQL 2000 table?
Posted on 2004-10-13
I am importing a text file that contains studentent identifcation information. Each student has a student Id. I read the text file and save it to a table. The program works fine. While it is processing, it will throw an exception based on the student Id saying there is a duplicate record. I hit ok and the program continues. This will occur about 10 times from start to finish. When I click ok, does it save the duplicate record or does it ignore the record and move to the next record. How do I know which record it is having a problem with?
Thanks in advance.