What is the fastest way to eliminate duplicate records

[muddasirmunir]

i want to know what is the fastest way to eliminate dublicate record
from file excel/access etc.

suppose i have a large database in excel/access with one some with
one field some with upto 10.
i did not want to delete it maually because it may take a long time also
error is possible

i am not actually getting the logic for it.
i have good know of proramming vb so can any body tell the logic for this

[jamesd0142]

chec out this post:

http://www.thescripts.com/forum/thre...duplicate.html

[Killer42]

In program logic, you can do something like a nested loop. For example...

For each record
  For each record after that one
    If they're the same, delete one of them
  Loop
Loop

In an SQL database, you can do a "find duplicates" query to identify them, then delete them. The query builder wizard in Access will build a query for you to find duplicates, then you can just adapt it to delete them. Or use the query as is and delete what it finds another way.

[muddasirmunir]

Thanks excellent tutorial