title: How can I insert multi rows
body: <p>I try to write the SQL code to enter the 1st 2 rows of data, based on the table shown below.
  My code:</p>
  
  <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'
  );
  
  INSERT INTO EMP_1 ( 
      EMP_NUM, EMP_LNAME, EMP_FNAME, EMP_INITIAL, EMP_HIREDATE, JOB_CODE 
  )
  VALUES (
      102,'Senior', 'David', 'H', '12-Jul-89', '501'
  );
  </code></pre>
  
  <p>But I keep get character error. I am using ms access 2007, ERROR" Charracter Found after end of SQL statement".</p>