Data dump Access to Excel

[Matt]

If I have a large amount of data (~300000 items) in access that I
would like to dump from Access into Excel. Is it possible to create
a
macro that will copy/paste the first 65536 items from access to
excel,
then run it in another excel sheet to copy/paste the next 65535 items
from access to excel, and so on?
Thanks for any ideas!

 

[Eric Blitzer]

Copy your table structure only.
add an auto number field
append records from old table to new table
create macro

Once you have done this you can reference the records with this auto nuber
field.
Use output to action in macro
In your query criteria for this new field put
between 1 to 65535
run again
use between 65536an .....

You could have it prompt you for the criteria by putting
between [Enter beginning number range] and [Enter ending number range]

 

[KARL DEWEY]

Another method is to add a Yes/No field named Export.

In your macro run a query to export with criteria for Export field FALSE and
TOP 65,000. Next in your macro run an update query to update the Export
field TRUE for the TOP 65,000.

Repeat macro until there are no more records exported.

To clear the data run an update query to update the Export field for FALSE.