"Ugafish" <ug********@mindspring.com> wrote in message
news:11*********************@e56g2000cwe.googlegro ups.com...
I have a real estate database which shows sales of properties dating
back to 2001. I want to copy the sales transactions from 01/01/05 to
the present. The entire database has over 54000 records and I just want
the present sales. Can this be done?
I'm assuming that you want to do this "live" (as opposed to through VBA) .
1. Create a query to select the records you want to export
2. Change the query to a Make Table query (choose some descriptive table
name)
3. Run the query
4. Right-click on the newly created table and export, then follow the
instructions.
Good Luck,
Fred Zuckerman