I have a database that is tracking dimensional data.  In order to do some
further analysis of this data I use a program called Mintab.  So I'm
entering the data into Access, querying the data using Access, then
exporting the data to Excel, and finally copying and pasting into Mintab.  A
long way it seems but really not that much at all, or so I think.
With that said here's my question/problem.
The query has many dimensional entries.  An example would be;
Part # 1
Hole Size 1    Hole Size 2    Hole Size 3
2.000               2.001          2.004
Part # 2
Hole Size 1    Hole Size 2    Hole Size 3
 2.001            1.999            2.002
Part # 3
Hole Size 1    Hole Size 2    Hole Size 3
 2.002            2.001            2.003
etc.
When this data is in Access and is exported into an Excel format it read
across, from left to right (landscape if you will).
This is where I'm looking for help.  Is there a way to have Access or Excel
auto format all of this data changing it from left to right and make it read
top to bottom?  Right now I copy and paste (using paste special/transpose in
Excel).  As this amount of information increases the task of formatting the
columns as I'm doing now will be a huge task.
Is there a way to do this that I'm missing?
If more information is needed just ask.
Thanks for your help,