title: Exporting data from MS Access to Excel using VBA
body: <p>I have a table in MS Access, which has the following data to be exported to excel</p>
  
  <ol>
  <li>Release numbers</li>
  <li>Test cases</li>
  <li>Results</li>
  </ol>
  
  <p>After exporting to Excel I want to have distinct release numbers as rows starting from A2 and distinct test case name as columns starting from B1. There might be couple thousands records. Then each cell will be set to result tag. Additionally will need some fancy coloring/bordering stuff.</p>
  
  <p>The question - is it possible to do this using VBA in Access and if yes what is the way to go? Any hint, sample, example, resource would be appreciated... I've googled but the most thing I came accross is <code>DoCmd.TransferSpreadsheet</code> or <code>DoCmd.OutputTo</code> which I believe will not do what I want. Saw some examples with <code>CreateObject("Excel.Application")</code> but not sure what are limitations and performance using this way.</p>