asked on

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?

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.

Kenny

ASKER CERTIFIED SOLUTION

bramsquad

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

osp70

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

Is this app something you did up yourself and you can modify?

If not then nothing can be done and you need a new app

if so similar to above, trap the student id but instead of a msgbox popping up why not write the error to an error file that you can review at your leisure when you need to.

just an idea.

kwh3856

ASKER

Thanks to each of you for your help. It is greatly appreicated.

Thanks
Kenny