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

[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

 

[Craig Alexander Morrison]

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?

 

[Guest]

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)

 

[Guest]

Time Machine option sounds a good one.

Cheers!

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)

 

[Guest]

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

 

[Craig Alexander Morrison]

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.