Transferring selected data from one database to another

[leogets]

If I have a newer database of movies. Is there any way to extract and apply the Seen and Not Seen state for movies in an older database to the newer database of movies? If a movie cannot be found in the older database, can it be marked automatically in the newer database as Not Seen?

Thanks for any help.

[rick.ca]

Export a list of movies from both databases (Title, Year and URL—to ensure proper matching—plus Viewed and ViewDate) to Excel. Set Viewed/ViewDate in the new list to that in the old, and if there's no match, set them off/null (the date is optional—I'm assuming you might want it too). Re-import the revised list to update the new database.

I've skipped the details of how to import, export and lookup values in Excel. If you're interested in doing this, search for other posts on those topics, and ask whatever specific questions you may have.