How do I export more than 65000 rows data from Acess into Excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have an Access table of over 150,000 rows of data that needs exporting into
Excel. Is there a better way to do this other than copy and paste sections
onto different excel worksheets
 
You can't the limit is 65536.

You could use queries to get the data in more meaningful order, however each
query would have to return less than the excel limit.

Finally, do you really HAVE to use Excel?
 
I see that the next version of Excel will be able to help you.

So your choices are:

Do something different.
Use a time machine to advance forward until Excel 12 is released.
Put the project on the shelf until Excel 12 is released.

(david)
 
Time Machine option sounds a good one.

Cheers!

david@epsomdotcomdotau said:
I see that the next version of Excel will be able to help you.

So your choices are:

Do something different.
Use a time machine to advance forward until Excel 12 is released.
Put the project on the shelf until Excel 12 is released.

(david)
Click to expand...
 
Yes, I'm aware of the excel limitations (the dreaded 65K). Perhaps I should
have been more precise - Is there a wizzy feature of Access that will take
the access table, export it up to a designated level (say 50k rows) to a text
or excel file and when this designated level is reached, open a new file or
worksheet on the existing file, export a further 50k rows etc, etc.??



Anyway, thanks for the reply
 
Have you tried my suggestion about queries to limit the number of rows?

One such feature is the TOP statement in SQL which can specify the number of
records.

You may also use the inherent data to create shorter lists say everything
State by State or whatever suits your data.
 
Back
Top