title: insert into query without listing destination fields explicitly
body: <p>In an MS Access 2010 database, I have a massive table that I need to shrink in order to make it usable.  I am only interested in a subset of the records in the table, so I want to select all the data that I care about and insert it into another table that has all the same identical fields.  The problem is that the table has MANY fields and it would be error-prone to list them all explicitly.  Is there some way to simply select all fields and insert into all fields without listing each field explicitly?  If so, how do I change the following code in order to accomplish this?  </p>
  
  <p>INSERT INTO massivetable_destination (*)<br>
  SELECT * FROM massivetable_source<br>
  WHERE State='MS';  </p>