exporting to excel

[Guest]

How can I automatically cut a database in half and export to two excel files.
My database is 76,000 records and excel can only hold 65,000. Is there a
way to simply cut the database in half?

 

[Guest]

If there is any column in the table that sequences up - then you would only
have to put a criteria in a query that is approximately half way....

you can make a MakeTable query with all columns...but in the criteria of the
column in question put in
<xxxxx

where xxxxx is about the half way value...

If any column has a numeric value that is increasing thru out line by
line...then pick a value about half way..

For instance if one column is last names - which would be alpha
sorted....then put in the criteria field: < L since L is about half way
thru the alphabet...

then of course you will make another MakeTable query with the criteria just
the opposite...i.e. >k

you will end up with two new tables each with about half....