>It isn't a huge number of records. There are a large number of fields however. I wouldn't mind doing it one record at a time if need be. I simply need to copy the records and append them to the end of the table, then change one identifier field.

Is the identifier field (the one you have to change) part of a key structure that doesn't allow duplicates? In that case you probably need to make the change before trying the append