Generating reports with MS Excel 2003
 

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

Generating reports with MS Excel 2003
 

Let us have a glimpse of the dumped file and report would be helpful please.
--
Regards

"Jay" wrote in message
...
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

Generating reports with MS Excel 2003
 

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

Generating reports with MS Excel 2003
 

Thanks Anitadai, i will give this a try,

As for the other post i would not share the information as it is corporate
reports which would be in violation of our policy. I just needed a general
direction on how to best accomplish the task @ hand.



"anitadai" wrote:

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