Re: delete duplicates, how?
From: Charles Kivio <charles_at_carus.fi>
Date: 13 Feb 1999 23:25:02 GMT
Message-ID: <01be57a7$ac7d4b80$6ea36fc2_at_ncatosh>
Date: 13 Feb 1999 23:25:02 GMT
Message-ID: <01be57a7$ac7d4b80$6ea36fc2_at_ncatosh>
This is a bit dirty but:
Fire up MS-Access, connect thru ODBC and run the "Find Duplicates Wizard"
look at the SQL code produced...
I think there is a delete option to...
/Charles
Rune Lysbakken <lysbakke_at_online.no> wrote in article
<36c28c6b.388959_at_news.online.no>...
> I want to create an unique index but I have some duplicate values. I
> think I can find them with a combination of count, group and having
> Count ()> 1 but how can I delete so that only one of the duplicates
> remains? Use rowid perhaps?
>
> regds Rune
>
Received on Sun Feb 14 1999 - 00:25:02 CET