Divide Large Table

  • Thread starter Thread starter Scott
  • Start date Start date
S

Scott

I have a table that has 174,000 rows. I want to be able
to divide that table into 3 smaller tables and export
them out as .xls files. Is there an easy way to do this?

Thanks,

Scott
 
Since I am a newbie, are there any instructions on how to
do this?
-----Original Message-----
You can use Make Table queries where you have criteria
Click to expand...
that might restrict the data into thirds, like IDNumber
between 1 and 55,000. Then export the resulting 3 tables.
 
I have a table that has 174,000 rows. I want to be able
to divide that table into 3 smaller tables and export
them out as .xls files. Is there an easy way to do this?

Thanks,

Scott
Click to expand...

It's not necessary to create any new tables. You can export to Excel
perfectly well from a Query.

However, even if you do create new tables, you'll need some sort of
criterion based on values in the Table to define which records go in
which export. Is there some field in the table that you can use to
define subsets? Access has no "row numbers" so you will need to use
something actually in the data to do this!
 
I am unfamiliar with the entire process that you just
explained. Any help with it would be great!

Scott
 
I am unfamiliar with the entire process that you just
explained. Any help with it would be great!
Click to expand...

I am even less familiar with the structure of your tables, or with the
possible answers to my questions. Any help would be appreciated (and
hopefully will allow me to post some detailed instructions). You can
see your database... I cannot (and no, thank you, please don't send me
a copy).
 
I was actually working on it and found that I could sort
the table first by one column and then be another, which
is what I want to do. I then added a primary key field
so that I could have a number on each row to query from.
Everything is great except that after the primary key is
entered, the sort gets messed up. How can i keep this
from happening? If I could get passed that, I would
have a solution.

Scott
 
I was actually working on it and found that I could sort
the table first by one column and then be another, which
is what I want to do. I then added a primary key field
so that I could have a number on each row to query from.
Everything is great except that after the primary key is
entered, the sort gets messed up. How can i keep this
from happening? If I could get passed that, I would
have a solution.
Click to expand...

A table HAS NO ORDER. It's an unordered "Bag" of data. The sort
buttons control the order in which the records are displayed but have
absolutely NO effect on how the records are stored.

You must - no option! - use the value of some field or fields within
the table to specify a sort in a Query, or (for the purpose of
exporting your data) provide criteria selecting which subset of the
data you want to export. If you want to export Row 1 through Row 50000
*you are out of luck* - because there IS nothing within Access to
define "row numbers".
 
Back
Top