# Error 1062 Duplicate entry '0' for key 1

**URL:** <https://community.open-emr.org/t/error-1062-duplicate-entry-0-for-key-1/6121>\
**Category:** OpenEMR Development\
**Created:** [January 26, 2008, 7:24pm UTC](https://community.open-emr.org/t/error-1062-duplicate-entry-0-for-key-1/6121 "2008-01-26T19:24:15Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![system](https://discourse-uploads-openemr.s3.dualstack.us-east-1.amazonaws.com/original/2X/b/bb9e4e8ae2ea7faac2e952fd9e38a3ce03aac403.png) [@system](https://community.open-emr.org/u/system)\
**Post date:** [January 26, 2008, 7:24pm UTC](https://community.open-emr.org/t/error-1062-duplicate-entry-0-for-key-1/6121/1 "2008-01-26T19:24:15Z")

</div>

**[mike-h30](https://sourceforge.net/u/mike-h30/)** wrote on [Saturday, January 26, 2008](https://sourceforge.net/p/openemr/discussion/202506/thread/77531096/#795f):

I am in the process of migrating Microsoft Access data via a text file into the OpenEMR database. I am using the GUI tool Navicat8 to import the text file and map the fields accordingly. The first table I am trying to populate is patient\_data.&nbsp; I believe the source of my error stems from the default value of ‘0’ for the following 3 fields in patient\_data: “pharmacy\_id”, “pid”, “fitness”.

I do not have values to populate for these fields in my text file.&nbsp; Please advise.

Regards,

-Mike