title: How do I insert data from a query select string into a table in Access?
body: <p>My question was deleted because of duplicate but this is not the case. My example uses an already made sql-string. The answer SO does not and where SO is referring to is way to complicated to implement in my solution. I try to edit my post and be more clearly about my issue. So I have a form which connects to an external database. My query qry_LIMS selects the relevant data.</p>
  <pre><code>    LIDNUMMER = &quot;([LIDNUMMER] = &quot; &amp; LIDNUMMER_Integer &amp; &quot;)&quot;
      MONSTERTYPE = &quot;([MONSTERTYPE] = '&quot; &amp; Monstertype_String &amp; &quot;')&quot;
      MONSTERNDATUM = &quot;([MONSTERNDATUM] = '&quot; &amp; Datum_String &amp; &quot;')&quot;
  
      
      strCriteria = LIDNUMMER &amp; &quot;And&quot; &amp; MONSTERTYPE &amp; &quot;And&quot; &amp; MONSTERNDATUM
      
      task = &quot;Select * from qry_LIMS where (&quot; &amp; strCriteria &amp; &quot;)&quot;
  
      Me.Form.RecordSource = task
  </code></pre>
  <p>What is the most easy way to insert all records from <code>task</code> into an other table named <code>tbl_LIMS</code>?</p>
  <p>The named fields of my table <code>tbl_LIMS</code> are the same as <code>qry_LIMS</code>:</p>
  <pre><code>Lidnummer
  Monstertype
  Monsterndatum
  </code></pre>
  <p>I think the solution would rather easy but I do not seem to get it</p>
  <pre><code>INSERT INTO tbl_LIMS VALUES (task)
  </code></pre>