I'd suggest scanning the outside database and insert into your table. I've used a work around before on one-time appends of turning the primary setting of my tag, appending the data, generate the key id, and then resetting the tag as primary.

>My table have a primary key: iKey
>
>This key is generated automatically by a call to NewID() in the "Default value" field.
>
>It does work well with APPEND and INSERT_SQL, but it does not work with APPEND FROM. The function NewID() is never called by APPEND FROM, leaving me with "The primary key is violated" message.
>
>Is there any work around for this problem or do I have to import the file in a temporary table (without a primary key) before importing it again in my table?
>
>TIA