>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
Sylvain,
That is because you are probviding a value with append from. You cang et you default value to work if you APPEND FROM FIELDS ... and list all fields EXCEPT the primary key field.