Sure.
To create a new table: In the database window, select your exiting table,
copy it and then paste it back into the same window. Select the dialog box
"structure only", and select a new name.
Now to the query:
Create a new query based on the old table. Select all the fields
individually with the exception of the primary key field(s).
Turn on the "totals" function. This will preset all fields to "Group By".
Run the query.
I suspect that you will still get what you would consider duplicate records,
but which Access doesn't. Take a group of these records that you consider
duplicate and compare them field by field until you find a difference. You
then need to tell access which of the group you want it to use by chaning the
totals function for that field to something other than "group by" (min, max,
sum, first, last etc).
If you can't formulate a set of rules to return exactly the records you
need, then you may have to weed out the unwanteds by hand.
If you can get the query to your liking, turn it into an append query and
fill your new table.
I
