Data dump

  • Thread starter Thread starter Matt
  • Start date Start date
M

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!
 
Why not copy the table structure and add an autonumber field to that table.
Append the records. All the records will have an unique identifyer or line
number. Export the records using the line number for your range. Once you
have the table created the rest can be automated in a macro.
 
I guess I'm not very Access-savvy. Would you break that down about
how exactly you would do that?
 
Back
Top