I
ironwood9 via AccessMonster.com
I have a table that I regularly append records to, and this is an automatic
process daily - the problem is, the recordset being used to append to my main
existing table always have a large percentage of duplicate records - the same
value for every single field.
My current workaround is to first create an empty shell table with a primary
key to accept only one unique record for each case of duplication, and after
first stripping any record out that has a duplicate, then taking that set of
unique records and appending them to my main table.
Is there a way to skip all these steps ?
process daily - the problem is, the recordset being used to append to my main
existing table always have a large percentage of duplicate records - the same
value for every single field.
My current workaround is to first create an empty shell table with a primary
key to accept only one unique record for each case of duplication, and after
first stripping any record out that has a duplicate, then taking that set of
unique records and appending them to my main table.
Is there a way to skip all these steps ?