I usually handle this situation like this:
Drop the autoincrement column from the source table, e.g. if using APPEND FROM (XXX), drop the autoincement column from XXX prior to using APPEND FROM (XXX). This works fine whether the target table is empty or contains records.