G
Guest
A project that I am working on requires deletion of duplicated data from a
table. The table consists of only 1 field named Email Addresses. My plans
are to use the email addresses for sending email. I have used the text data
type instead of the hyperlink data type because I wish to perform sorting
operations alphabetically on them periodically as I continue to enter the
email addresses. So far, I have collected over 800 email addresses from
various sources. The hyperlink data type inhibited me from using the sort
feature.
While collecting the data from various sources, many duplicates are
produced. Therefore, I turned to the help files and located the topic,
Automatically Delete Duplicate Records from a Table. Every effort has been
made to follow the instructions meticulously.
Steps 1 –5 are fairly simple, creating a new table by copying and pasting in
the Database window.. Step 6 states to “Open the new table in Design view,
and select the field(s) that contained duplicates in the table you copied.â€
No problem here.
Step 7, which states, “Click Primary Key on the toolbar to create a primary
key based on the selected fields,†proceeds okay.
The difficulty begins with Step 8, which says to “Save and close the table.â€
When “Yes†is clicked, an error message appears stating, “The changes you
requested to the table were not successful because they would create
duplicate values in the Index, Primary Key, or relationships. Change the
data in the field or fields that contain duplicate data, remove the Index, or
redefine the index to permit duplicate entries and try again.â€
The second part of this help file is To append only unique records to the
new table.
Step 1, Create a new query based on the Original table containing duplicates.
Step 2, In query Design view, click the Query Type on the toolbar, and then
click Append Query.
Step 3, In the Append dialog box, click the name of the new table from the
Table Name list, and then click OK.
Step 4, Include all the fields from the original table by dragging the
asterisk (*) to the query design grid.
Step 5, Click Run on the toolbar.
Step 6, Click Yes when you receive the message that you’re about to append
rows.
Trouble begins here with Step 7, Click Yes when you receive the message that
Microsoft Access can’t append all the records in the append query. This
transfers only unique records to your new table and discards the duplicates.
This step does not appear. No error message appears.
Steps 8 and 9 to see the results cannot be performed.
The Office 2000 version of Access is being used on a Pentium III, 500 Mg
machine with a 120gg hard drive. Windows 98 is the operating system.
Please notice the problem at step 8.
Please help me to delete the duplicated records from my table.
Thank you.
table. The table consists of only 1 field named Email Addresses. My plans
are to use the email addresses for sending email. I have used the text data
type instead of the hyperlink data type because I wish to perform sorting
operations alphabetically on them periodically as I continue to enter the
email addresses. So far, I have collected over 800 email addresses from
various sources. The hyperlink data type inhibited me from using the sort
feature.
While collecting the data from various sources, many duplicates are
produced. Therefore, I turned to the help files and located the topic,
Automatically Delete Duplicate Records from a Table. Every effort has been
made to follow the instructions meticulously.
Steps 1 –5 are fairly simple, creating a new table by copying and pasting in
the Database window.. Step 6 states to “Open the new table in Design view,
and select the field(s) that contained duplicates in the table you copied.â€
No problem here.
Step 7, which states, “Click Primary Key on the toolbar to create a primary
key based on the selected fields,†proceeds okay.
The difficulty begins with Step 8, which says to “Save and close the table.â€
When “Yes†is clicked, an error message appears stating, “The changes you
requested to the table were not successful because they would create
duplicate values in the Index, Primary Key, or relationships. Change the
data in the field or fields that contain duplicate data, remove the Index, or
redefine the index to permit duplicate entries and try again.â€
The second part of this help file is To append only unique records to the
new table.
Step 1, Create a new query based on the Original table containing duplicates.
Step 2, In query Design view, click the Query Type on the toolbar, and then
click Append Query.
Step 3, In the Append dialog box, click the name of the new table from the
Table Name list, and then click OK.
Step 4, Include all the fields from the original table by dragging the
asterisk (*) to the query design grid.
Step 5, Click Run on the toolbar.
Step 6, Click Yes when you receive the message that you’re about to append
rows.
Trouble begins here with Step 7, Click Yes when you receive the message that
Microsoft Access can’t append all the records in the append query. This
transfers only unique records to your new table and discards the duplicates.
This step does not appear. No error message appears.
Steps 8 and 9 to see the results cannot be performed.
The Office 2000 version of Access is being used on a Pentium III, 500 Mg
machine with a 120gg hard drive. Windows 98 is the operating system.
Please notice the problem at step 8.
Please help me to delete the duplicated records from my table.
Thank you.