Error importing from Access

[Shadow]

Quote:

Duplicate entry '416' for key 1

The answer is in the SQL statement you included in your question: the statement tries to insert the value 416 to the field “id_termo”, but the table already contains a record with the same id_termo. id_termo is the primary key for the table (at least, I guess it is), so it must be unique.

Possible causes:

– you forgot to declare id_termo field as primary key in Access

– the Access db is corrupt (allowed the insertion of the same value more than once) – a slim chance

– you try to import records that already exist in the MySql db, try writing your own import query instead of copying the whole table

[Author]

Posts