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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Milton said:
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.
Click to expand...

What on earth for? You'd be going in the wrong direction. Multiple tables with
the same structure is almost never the right way to do a database.
 
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
 
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.
 
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?
 
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).
 
Back
Top