Re: 1 Million Rows ??

On Feb 3, 9:16 am, Kevin <K...@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
How can I import Access data that exceeds 65 rows? I understand that Excel
can now handle 1 million rows - but I cannot figure out how.

Hi Kevin,

Why don't you use the PivotTable function...

What it does is import all of the data into the memory of Excel and
caches it (very small file size/footprint), and then you can build the
table/report however you want...

As you use Data > Import External Data > New Database Query, you will
get to a point in the Wizard to use a PivotTable...

To be honest it's a little tricky for first time users, but are very
very powerful once you get the hang of it

.

Relevant Pages

  • Re: Open Delphi?
    ... Delphi, to be honest. ... That means you don't hang out enough on #fpc maillists and irc's :-) ...
    (borland.public.delphi.non-technical)
  • Re: Open Delphi?
    ... Delphi, to be honest. ... That means you don't hang out enough on #fpc maillists and irc's :-) ...
    (borland.public.delphi.non-technical)
  • Re: Mercy on Monye
    ... You have to have the ball to do that. ... You also need to be able to hang on to ... Very basic skills but tricky ... its not tricky to do basic skills one after the other, ...
    (rec.sport.rugby.union)
  • Re: Banksy strikes Paris (link)
    ... of Books (that's what they call it, honest.) Ohbut, hang on, Worldcat ...
    (uk.rec.sheds)
  • Re: OT eBlag gets done for fake goods
    ... darsy's new signature would worry me IIWY. ... Hang on, I'll check... ... My position was (and, to be honest, largely remains) one of complete ambiguity. ...
    (uk.rec.motorcycles)