title: Access SQL - Insert multiple rows wont work
body: <pre><code>INSERT INTO EMP_1 (EMP_NUM, EMP_LNAME, EMP_FNAME, EMP_INITIAL, EMP_HIREDATE, JOB_CODE)
  VALUES ('101', 'News', 'John', 'G', '08-Nov-00', '502'),
  ('102', 'Senior', 'David', 'H', '12-Jul-89', '501');
  </code></pre>
  
  <p>I've been searching for quite some time and most people say to but the comma between the two sets but when I do that it says that it is missing a <code>;</code> at the end of the SQL statement so then I separate them with the <code>;</code> and get the error that talks about code after the semi-colon, which is understandable.</p>
  
  <p>I've even tried <code>SELECT</code> and <code>UNIONALL</code> to no avail and was just checking out <a href="https://stackoverflow.com/questions/62504/is-there-any-way-to-create-multiple-insert-statements-in-a-ms-access-query" title="Using select and union all">this</a> but it still recommended the <code>SELECT</code> and <code>UNIONALL</code>. Is there something I'm missing completely?</p>
  
  <p>I'm using MS Access 2016, thanks in advance for the help. </p>