title: VB.net/C# Copy records from one database to another
body: <p>I have 2 MS-Access databases with same structure but with differents data.
  I want to copy records from 1 database to the other.</p>
  
  <p>Example : </p>
  
  <hr>
  
  <pre><code>Database Source, table Person
  Record 1:
  Field 1, PersonNumber, primary key, value : 1
  Field 2, CompanyNumber, foreign key, value : 1
  </code></pre>
  
  <hr>
  
  <pre><code>Database Source, table Company
  Record 1:
  Field 1, CompanyNumber, primary key, value : 1
  Field 2, CompanyName, value : Microsoft
  </code></pre>
  
  <hr>
  
  <p>So, there is a relation between the 2 tables on CompanyNumber.</p>
  
  <p>So, if i want to copy these 2 records of the 2 tables in my destination database, i will probably have a problem if i already have a person or a company with a primary key with value 1 in destination tables.</p>
  
  <p>2nd problem, all my tables have many foreign key, how to copy records from person for example if records from company are not created ?</p>
  
  <p>How can i do with vb.net or C# ?</p>
  
  <p>Thanks for your help</p>