Trying to append rows of data from an imported table into a pre-existing table in my database but all rows failing to append due to a key violation error. There's 10+ fields but I systematically removed fields and tried re-running the query each time to see if I could isolate the problematic field, no individual field seems to be problematic. Also manually checked to make sure all data types and field properties are the same in both the source and destination table.

Also tried disabling the primary key of each table. Source table has primary key ID's as alphanumeric strings auto-generated by Fulcrum (from where it was exported), so these need to append to the primary key field of the destination table. Currently just trying to append only the primary key field to keep it simple why I search for the source of the issue. Also tried looking in the Indexes but I'm not sure exactly how that part works.

INSERT INTO
    SiteData (ID)
SELECT
    [Myalup quads and veg unit].[_record_id]
FROM
    [Myalup quads and veg unit];