title: converting column names to use as row fields in Access
body: <p>I am importing sql into my Access database and am working on parsing the data into the correct tables and fields. I have run into an issue as my import creates column names and enters the values into the columns but the database uses those column names as row values and the values in a separate column</p>
  
  <p>Current table</p>
  
  <pre><code> SC | DO | temp | pH | etc
  
   val|val | val  |val | val
  </code></pre>
  
  <p>table I am attempting to parse into</p>
  
  <pre><code> Characteristic_Name | Result_Value
  
   SC                  |  val
   DO                  |  val
   temp                |  val
   pH                  |  val
   etc.                |  val
  </code></pre>
  
  <p>I have done a union query to get the results column to populate nicely but I cannot get the column names to parse
  Is there a way to do this? </p>