title: Northwind action query error msg "multi-valued fields are not allowed in select into statements"
body: <p>I downloaded a Northwind template and am unable to run any type of action queries on the app's tables.  I get error messages such as:</p>
  
  <ol>
  <li><p>"multi-valued fields are not allowed in select into statements".</p></li>
  <li><p>"Select* cannot be used in an insert query when the source or destination table contains mutli-value field"   </p></li>
  </ol>
  
  <p>Is there a way to run action queries to this app's tables without having to use VBA?</p>
  
  <p>Thank You very much in advance, Nathaniel</p>
  
  <pre><code>SELECT Orders.*, * INTO d
  FROM Orders;
  
  
  INSERT INTO [Copy Of Products] ( [Product Code], [Product Name], [List Price], [Supplier IDs], Discontinued, Category, Attachments )
  SELECT Sheet4.ID, Sheet4.DESCRIPTION, "1" AS Expr1, "11" AS Expr2, "False" AS Expr3, Sheet4.COMMODITY_CODE, "0" AS Expr4, *
  FROM Sheet4;
  </code></pre>