General discussion
August 22, 2003 at 08:42 AM
borginva

Removing Duplicated Entries

by borginva . Updated 23 years ago

We use a program called Clientele. It is upsized to SQL 2000, but we export the data into Access 2000. Something happened and 1000 calls were duplicated. When I try to remove them in SQL 1 by 1, it says the data is linked and if I want to remove it also. Saying yes was bad!
Is there a way, some query or something, to remove the data easily without loosing the original?

This discussion is locked

All Comments