title: Insert sequential code from select
body: <p>I'm having a problem, I need to import the data from <code>table2</code> to <code>table1</code>, I don't have the <code>code</code> field on <code>table2</code> and on the <code>table1</code> it is Auto Number, what I have to put <code>?HERE?</code> to my <code>code</code> be sequential?</p>
  
  <pre><code>INSERT INTO table1 ([code], [field1], [field2])
  SELECT ?HERE?, [field1], [field2]
  FROM [C:\MySystem\name.accdb].table2
  </code></pre>
  
  <p>Obs: It is MS Access</p>