More than 65,000 lines and ACCESS
 

Hi,

I'm using the reverse pivot technique suggested by Debra Dalgleish to
create a list dataset from which I can make a pivot table. The only
problem is that because there are so many years going across, whenever I
try to do this the computer tells me it was only able to do an
incomplete list because the full list exceeds 65,000 lines.

Apart from having to break the dataset down into smaller datasets, is
there some way that I could hook up the original dataset to an Access
database and do the reverse pivot technique successfully that way in
order to get a complete dataset list for the pivot table?

There are about 100 years going across.

Any suggestions would be much appreciated. Many thanks.

Matthew Kramer

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

More than 65,000 lines and ACCESS
 

The limitation is the output, not the input. How would using Access as a
data source (if it works, I don't know for this technique) and produces more
than 65K lines, how would that be accomodated by Excel, because
that is where the output must be placed.

On the other hand, A macro could probably be done to generate the output and
put it in Access.

When you say reverse pivot technique, I am thinking of a method on John
Walkenbach's site (not aware of one on Debra's so you could post the URL).
In any event if whatever technique produces more rows of output than Excel
has, then the limitation is Excel as the output.

--
Regards,
Tom Ogilvy


"matthew kramer" wrote in message
...
Hi,

I'm using the reverse pivot technique suggested by Debra Dalgleish to
create a list dataset from which I can make a pivot table. The only
problem is that because there are so many years going across, whenever I
try to do this the computer tells me it was only able to do an
incomplete list because the full list exceeds 65,000 lines.

Apart from having to break the dataset down into smaller datasets, is
there some way that I could hook up the original dataset to an Access
database and do the reverse pivot technique successfully that way in
order to get a complete dataset list for the pivot table?

There are about 100 years going across.

Any suggestions would be much appreciated. Many thanks.

Matthew Kramer

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

More than 65,000 lines and ACCESS
 

Tom Ogilvy wrote:
A macro could probably be done to generate the output and
put it in Access.

Take a look at this thread:

http://groups-beta.google.com/group/...d656705433579c

If you could post some more details, including a sample extract of your
data, I would be able to adapt this approach for your circumstances.
Jamie.

--