G
Guest
I'm running an append query to append data from one table to another.
These two tables have the exact same structure, data types, etc. However,
when I run the append query, about 5% of the records to be appended are not
appended. Access gives me a message that these records cannot be appended,
however, it does not create an error table as one would get if one merely
copied and pasted.
Copying and pasting is not an option as I am trying to append over 100,000
records while using a computer with limited memory. Is there a way to force
an append query to kick out its errors into an error table, such as that
which is created when a copy and paste operation generates errors?
Hope this is clear, thanks.
Dave
These two tables have the exact same structure, data types, etc. However,
when I run the append query, about 5% of the records to be appended are not
appended. Access gives me a message that these records cannot be appended,
however, it does not create an error table as one would get if one merely
copied and pasted.
Copying and pasting is not an option as I am trying to append over 100,000
records while using a computer with limited memory. Is there a way to force
an append query to kick out its errors into an error table, such as that
which is created when a copy and paste operation generates errors?
Hope this is clear, thanks.
Dave