randusoleis
IS-IT--Management
I have transfered data from a dbf into Access and found that I have multiple dupes out of the 28,000+ records. I need to find these dupes and delete them. How can this be done. Randusoleis.....
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Show Dupes?
- Thread starter randusoleis
- Start date
- Status
mdthornton
Programmer
select distinct orig_table.* into tmp_table from orig_table
verify the contents of tmp_table then rename orig_table to orig_table_bak and rename tmp_table to orig_table.
Best Regards,
Mike
verify the contents of tmp_table then rename orig_table to orig_table_bak and rename tmp_table to orig_table.
Best Regards,
Mike
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question