Unanswered: Moving Records from One database to another.... Newbie help!
I am very new to MS Access, but understand the basics (tables, fields, forms and queries) but I have come across a situation that I am not sure how to solve...
I have 2 databases, both are identical and each contain 5 tables. One is a "live" database, with information being written to it regularly. The other db is for archival purposes. So when a set of records in the "live" db become obsolete, I want to be able to move them into their respective tables in the archival db.
My current method...
1. isolate the records to move by using a filter
2. export the records to excel
3. import the excel into the archive db
4. delete the records in the 1st db
I cannot believe that this is the only way of doing it! There must be a more efficient way than this!
Does anyone have a proposed solution? can I "connect" 2 databases and move records, or perhaps a macro might do it? I am open to any suggestions!