Exporting without overwriting - how to?

[Mike14]

First - whoever reads this and ponders a solution let me thank you in advance. This may be so simple I can't see the forest for the trees but ......

In my database for tracking fleet repairs when a job has been completed I need to eliminate it (omit) from the active database and export (I think) to another file. The problem is when I do this it always overwrites the "storage" file. I don't want to replace these old files but rather append them to the old file for future recall. Is this that difficult or I am over looking something really basic. Thanks again for whatever assistance you can render. Mike

[cjaeger]

instead of exporting from the original file try importing into the archive file, then deleting the records in the original.

[Lee Smith]

Start by doing a find for the records to be move to your archive database. Once you have a found set in your "Active" database you can then import the records and add them to your archive database by selecting your "Archive" database in your import. Before clicking okay, however you need to make sure that "Add New Records" in the Import Option Box is check, line up your fields to each file and click okay.

I always check the number in the found set of the Archive DB and make sure that it matches the found set number in active. I also do a spot check of the record to make sure what I wanted to be in the records shows up. Easy to miss a field or two the first time. Once you have this set the way you want, I would create a new button and create a script to automate it.

HTH

Lee

[Mike14]

Thanks for your timely response - between your reply and the subsequent reply I believe I have the solution in hand. thanks again - Mike