Exporting large Access query to Excel

  • Thread starter Thread starter Floydene
  • Start date Start date
F

Floydene

I have a query resulting in 1,090,282 records. I know that if I select all,
I can copy around 65K and paste it into Excel. But what about the rest of
the records? Is there any other way to copy the next 65K quickly? Or start
at record 65001 and select the remaining records (I would do a Ctrl-End in
Excel)? Any tips would be greatly appreciated.

I have Access and Excel 2007, so am not worried about exceeding the page
limit.

Thanks!
 
Hi,
Let me jump on the bandwagon first :)

Why would you want to?

but I will also say in your situation you can't ( At least not in one
column area for each record [You could use two column areas or multiple
worksheets])
Worksheet size 1,048,576 rows by 16,384 columns [2007]

So for mulitple worksheet I would use the "Export" feature after you limit
the data to 2 or more queries.

But again why - with that much data I would assume anything you need to do
with it would be better done through Access. And now you need two or more
worksheets - Possibly even harder now.

Craig
 
Back
Top