title: How to copy a linked table to a local table in Ms Access programmatically?
body: <p>So I'd like to copy a linked table to a local one in code, structure and data in MS Access 2003.</p>
  
  <p>Code being : VBA or C#.  Or anything else for that matter..</p>
  
  <p>UPDATE : I want the copy structure and data behaviour from ms access to keep the Primary Keys. If you copy a linked table, you can choose to paste it as 'structure and data (local table)'
  It is that I want to achieve in code.</p>