# PID's - Migrating from Access DB

**URL:** <https://community.open-emr.org/t/pids-migrating-from-access-db/4992>\
**Category:** OpenEMR Development\
**Created:** [February 2, 2008, 11:35pm UTC](https://community.open-emr.org/t/pids-migrating-from-access-db/4992 "2008-02-02T23:35:59Z")\
**Posts on this page:** 2\
**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:** [February 2, 2008, 11:35pm UTC](https://community.open-emr.org/t/pids-migrating-from-access-db/4992/1 "2008-02-02T23:35:59Z")

</div>

**[mike-h30](https://sourceforge.net/u/mike-h30/)** wrote on [Saturday, February 02, 2008](https://sourceforge.net/p/openemr/discussion/202506/thread/13ecd65d/#b636):

I am planning on migrating my patient demographics and SOAP data from an Access DB when we go live with OpenEMR-2.8.3.&nbsp; The PID’s in our Access db start at “1001.”

Is there any harm in keeping this numbering sequence or should I re-number at "1" when importing into Open EMR?&nbsp; The only reason why I would keep the old numbering sequence is for easier link up to the SOAP data ( The SOAP data in our Access db is in one table.&nbsp; Where as in OpenEMR I must account for the "Forms" and "Forms\_SOAP" tables).

Regards,

-Mike

---

<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:** [February 3, 2008, 12:30am UTC](https://community.open-emr.org/t/pids-migrating-from-access-db/4992/2 "2008-02-03T00:30:21Z")

</div>

**[sunsetsystems](https://sourceforge.net/u/sunsetsystems/)** wrote on [Sunday, February 03, 2008](https://sourceforge.net/p/openemr/discussion/202506/thread/13ecd65d/#b636/6be1):

I think it will be fine to start with your existing PIDs.

Rod  
[www.sunsetsystems.com](http://www.sunsetsystems.com)
