title: How to convert fields into rows through SQL in MS Access 2007 or MS SQL Server 2005
body: <p>I have a legacy MS Access 2007 table that contains 52 fields (1 field for each week of the year) representing historical sales data (plus one field for the year actually). I would like to convert this database into a more conventional Time/Value listing.</p>
  
  <p>Does anyone knows how to do that without writing queries with 52+ explicit parameters?</p>
  
  <p>(if a solution exists under MS SQL Server 2005, I can also export/import the table)</p>