Exporting Table to Multiple Excel Spreadsheets

C

cbcrocker

Please bear with me as I have very little Access experience. I've an Access
database with over 550,000 records each containing 25 fields. Is there a way
to export the records to Excel in say 50,000 record increments? Again, I've
little experience so I need detailed information.
 
A

Arvin Meyer [MVP]

It is easy to do manually if you have an incremental autonumber in the
table. Write a query like:

Select * From MyTable Where ID >=1 And <= 50000);

Now use the TransferSpread sheet method in code, or a macro to move the data
to a spreadsheet.

If you can write code you can use a loop which also increments the
spreadsheet file name. If you cannot write code, use presaved macros to do
them one at a time.
 
Top