Data dump

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!
 
G

Guest

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.
 
M

Matt

I guess I'm not very Access-savvy. Would you break that down about
how exactly you would do that?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top