Deleting Duplicate Entries

  • Thread starter Kristian A Ward - www.syssol.ca
  • Start date
K

Kristian A Ward - www.syssol.ca

I have a 16,000 entries that i have to go threw and delete multiple entries
and i really dont feel like going threw and deleting one at a time.

I thaught of using the distinct string but i think i may be doing in
correctly...here is an example of what im doing...

1- 0001
2- 0001
3-0001
4-0002
5-0002
6-0002
7- 0003
8-0003
9-0003

so i want them to delete them with out leaving any

any suggestions?

Kristian Ward
System Solutions
www.syssol.ca
[email protected]
 
M

Michel Walsh

Hi,


With Jet? Append the data into a new table not allowing duplicated
values. You will get error messages like xxxx records won't be appended, but
that is exactly what you want.


Hoping it may help,
Vanderghast, Access MVP

"Kristian A Ward - www.syssol.ca" <Kristian A Ward -
[email protected]> wrote in message
news:[email protected]...
 
K

Kristian A Ward - www.syssol.ca

Thank You,

What i did was i exported it into excel and did it threw there....

Thanks Again

Kristian
 
Top