Hi, all!
I know this is likely a silly question, but I'm still pretty new to Access, and just now starting to look at importing data. I've tried Google, but I haven't been able to find an answer for this.
My database is going to be taking in claim information in two ways: imports from the main database going forward, and manual entry of claims that predate that system, and corrections to claims that come from it with errors. My question is, if I have one table for claims, can I set up the import to only update those where the claim # matches, leaving the manually-entered claims as they are? Also, is there any way that I might be able to spare fields in the previously imported claims that have been corrected by users?