Imported text file w/o unique identifiers, find duplicates

Imported a txt file w/o unique identifiers and have run a query to find
possible duplicate records based on 3 seperate fields. How can I either
update those fields that may be in error in the original table or append a
new record w/o the duplicate data and delete the original record? In the
following I need to determine which records to keep, which to delete and/or
which to update.

End Date Total Sheets Time Operator Name
3/3/2007 14 0:00 00094123 B D MCNARA
3/3/2007 14 0:00 00095681 NAME UNKNOWN
3/17/2007 84 0:01 00091234 C D S
3/17/2007 84 0:01 00097282 J M Rob

Update....I was considering having the operator hit a checkbox or something
to indicate if a record needs to be deleted, however can't figure out how to
get this delete query to delete that record from the original txt file, not
the query that I used to locate it? Would that work, and how?

"jeremiah" wrote:

Imported a txt file w/o unique identifiers and have run a query to find
possible duplicate records based on 3 seperate fields. How can I either
update those fields that may be in error in the original table or append a
new record w/o the duplicate data and delete the original record? In the
following I need to determine which records to keep, which to delete and/or
which to update.

End Date Total Sheets Time Operator Name
3/3/2007 14 0:00 00094123 B D MCNARA
3/3/2007 14 0:00 00095681 NAME UNKNOWN
3/17/2007 84 0:01 00091234 C D S
3/17/2007 84 0:01 00097282 J M Rob

You might read these records into a temporary table that also contains a
Yes/No field.

Then you create a "Find Duplicates" query that uses whichever fields you
think should be unique to identify the duplicates. Then, display a
continuous form based on the duplicates query and allow the user to check the
yes/No field for those records that are to be deleted. Add a "Delete
Checked" button in the footer of this form, and run a query that deletes the
checked records and then requeries the form. Once there are no "duplicates"
in the list, allow the user to append the remaining records to your main
table.

HTH
Dale
--
Don''t forget to rate the post if it was helpful!

email address is invalid
Please reply to newsgroup only.



"jeremiah" wrote:

Update....I was considering having the operator hit a checkbox or something
to indicate if a record needs to be deleted, however can't figure out how to
get this delete query to delete that record from the original txt file, not
the query that I used to locate it? Would that work, and how?

"jeremiah" wrote:

Imported a txt file w/o unique identifiers and have run a query to find
possible duplicate records based on 3 seperate fields. How can I either
update those fields that may be in error in the original table or append a
new record w/o the duplicate data and delete the original record? In the
following I need to determine which records to keep, which to delete and/or
which to update.

End Date Total Sheets Time Operator Name
3/3/2007 14 0:00 00094123 B D MCNARA
3/3/2007 14 0:00 00095681 NAME UNKNOWN
3/17/2007 84 0:01 00091234 C D S
3/17/2007 84 0:01 00097282 J M Rob

Thank you Dale, once again this community has saved me....

"Dale Fye" wrote:

You might read these records into a temporary table that also contains a
Yes/No field.

Then you create a "Find Duplicates" query that uses whichever fields you
think should be unique to identify the duplicates. Then, display a
continuous form based on the duplicates query and allow the user to check the
yes/No field for those records that are to be deleted. Add a "Delete
Checked" button in the footer of this form, and run a query that deletes the
checked records and then requeries the form. Once there are no "duplicates"
in the list, allow the user to append the remaining records to your main
table.

HTH
Dale
--
Don''t forget to rate the post if it was helpful!

email address is invalid
Please reply to newsgroup only.



"jeremiah" wrote:

Update....I was considering having the operator hit a checkbox or something
to indicate if a record needs to be deleted, however can't figure out how to
get this delete query to delete that record from the original txt file, not
the query that I used to locate it? Would that work, and how?

"jeremiah" wrote:

Imported a txt file w/o unique identifiers and have run a query to find
possible duplicate records based on 3 seperate fields. How can I either
update those fields that may be in error in the original table or append a
new record w/o the duplicate data and delete the original record? In the
following I need to determine which records to keep, which to delete and/or
which to update.

End Date Total Sheets Time Operator Name
3/3/2007 14 0:00 00094123 B D MCNARA
3/3/2007 14 0:00 00095681 NAME UNKNOWN
3/17/2007 84 0:01 00091234 C D S
3/17/2007 84 0:01 00097282 J M Rob