Jay,
Import the data into Excel using a Pivot Table Report. Then you can arrange
the data the way you want, drill down to the details, create charts, etc.
Reports can be printed on different pages for different areas as well.
You'll love it.

anitadai

"Jay" wrote:

My question to someone with experience in excel is this.

We are trying to import data that is dumped from a source to a destination
and thn generate reports on certain criteria within our workbook. We want to
be able to analyze Volume on our phone switches which would include multiple
metrics. My question is excel the best choice for this or would a DB be more
efficient @ this task. The problem we run into with Access is the file name
length of 64 characters Max. some of our dumped files exceed these lenghts..

Any insight would be highly appreciated