F
Faxylady
Automatically Deleting Duplicated Data from a Table 040104
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.
At present, I do not have Internet access. I have to use
public computers available from libraries.
Please help me to delete the duplicated records from my
table.
Sending email to (e-mail address removed) would be most
appreciated.
Thank you.
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.
At present, I do not have Internet access. I have to use
public computers available from libraries.
Please help me to delete the duplicated records from my
table.
Sending email to (e-mail address removed) would be most
appreciated.
Thank you.