On Feb 3, 9:16 am, Kevin 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