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