Re: Import Wizard Violation of PRIMARY KEY constraint error
Had this error occur today:
Exception occurred in application Recorder 6 at 20/05/2008 13-48-32.
Version : 6.10.4.120
Exception path:
EOleException : Violation of PRIMARY KEY constraint 'PK__#RN_Taxon_Occurr__226FEF70'. Cannot insert duplicate key in object 'dbo.#RN_Taxon_Occurrence_Data'
I managed to track down the cause to the following being present in the Abundance column:
present,present
I removed the comma and the crash was no longer triggered.
Digital Development Manager | Field Studies Council
http://www.field-studies-council.org | https://twitter.com/charlesroper | https://twitter.com/fsc_digital