title: Insert multiple rows using one insert statement in Access 2010
body: <p>I want to insert multiple values into an Access 2010 table, but I can't seem to find a way.<br>
  MySQL had a nice way:</p>
  
  <pre><code>INSERT INTO Production.UnitMeasure
  VALUES 
      (N'FT2', N'Square Feet ', '20080923'),
      (N'Y', N'Yards', '20080923'),
      (N'Y3', N'Cubic Yards', '20080923');
  </code></pre>
  
  <p>Can something like this be done in SQL Server too?</p>