Re: 1 Million Rows ??

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

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: With Geena Davis-like training, which Winter Olympic sport could YOU dominate?
    ... I can't accept that as prima facie true. ... To be completely honest, ... the sweeping looks very tricky to me, ...
    (rec.sport.football.college)
  • 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: 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)