Count consecutive values down a Col #2

  • Thread starter Thread starter Jon Macmichael
  • Start date Start date
J

Jon Macmichael

Frank,

Sorry I had to put this under a new post. Did something wrong on the
original thread... and could only get an "unable to retrieve message"
error?

You bought the Pivot Table back to life. Made a few runs (I have many
files to do), and it works very well. I found that the data needs
importing into Access as text for the Pivot Table to provide a 'count'
rather than 'sum' when data is formatted as number.

However, by first having to import the data into Access (into a
manually configured ('Design View') the overall process is made slow,
as I have so many files to do. Guess if I could write code in Access,
then this could be overcome.

But for now, I'm between a rock and a hard place. Considering the
large quantity of files I'd need to first import, do you think it
would not be faster to correct the script I wrote for Excel (with Chip
Pearson's Import Macro, at least it's off to a flying start)?

Appreciate your help very much.

Jon
 
Hi John
1. Pivot tables should< also offer a count for 'numbers'. You can
change this default aggregagation function
2. Not sure which of Chip's macros you're suing?
 
Frank,

Pivot Tables probably do have a count for 'numbers', just that I've
hardly used Pivot Tables and don't know my way around to much.

Your suggestion for importing the data via Access has worked extremely
well, except for one thing; have to first make/import the data (I have
many stock market symbols to import, and again I don't know access too
well, so don't know how to say import many text files at one time,
into individual tables in access. It's a 'one-at-a-time' affair).
However, the excel side of manipulating the data has speeded up alot.

The Chip Pearson macro was just the 'Import Text'. Think it's the only
one like it. I was wondering if the whole process would be expediated
if my count macro (on the previous thread) could be made to work. But
now I'd like to be able to follow your route. I have the macro side of
excel fairly polished for my standards. Just like to get the importing
of similar stock market data text files importing faster into Access.

Many Thanks
Jon
 
Back
Top