Split Access table into 2

[Kathy - Lovullo]

I have an access table that has over 500,000 records. Based on the
transcation date field in the table, I would like to split this into 2
separate tables.

Is there a quick and easy way to do this? I copied the table. Then I was
deleting the rows not needed by highlighting - right mouse click - delete.
This is very time consuming scrolling through to select all the records. Is
there a quicker way to split this table?

Thanks!

 

[Douglas J. Steele]

Why do you want to split it?

If you have a legitimate reason (500,000 records isn't one, by the way), you
can use a Make Table query to copy all of the records before a specific
date, and then a Delete query to delete the ones you just copied:

SELECT Field1, Field2, Field3
FROM Table1 INTO Table2
WHERE MyDateField < #2009-01-01#

DELETE
FROM Table1
WHERE MyDateField < #2009-01-01#