How to break up a 9000 record table into smaller ones using VBA?

  • Thread starter Milton R in California
  • Start date
M

Milton R in California

I need to break a 9000 (it might be larger later) into smaller tables
containing 700 records each. Each table would be named, say Toys, serialize,
Toys1, Toys2, etc.
 
M

Milton R in California

Rick:


Thanks for your response. I bit more clarification might help in seeing what
my goal is. I would like to be able to export to a text file a small number
of records, 900 max., for another application to process. This other
application has record limitations I can’t override.

Thanks
Milton
 
D

Douglas J. Steele

To reiterate Rick's advice, do not split them into separate tables.

Instead, write some queries that return the appropriate number of rows, and
export the queries, rather than tables.
 
M

Milton R in California

Okay, that sounds good, and I actually tried to do this first. However, I run
into problems when the only criteria I have for creating the queries is that
the first query would return the first 900 records, which is easy to do; but
how do I make the subsequent queries return the following 900, and the next
900, etc. until all records from the table are exhausted?
 
D

Douglas J. Steele

I was under the impression that you had some way of splitting your data into
smaller bits, by selecting only records with a specific value (or values).
 
Top