I have an Access Database in which a user will import a table to get payments from. However the file being imported for some accounts may have more up to date information on it such as names and addresses(Any differences will be more up to date). There are a lot fields making it hard to compare each individual fields for differences and too many records at a time to really create a loop. Is there anyway to create a query to replace fields in Table A that are different than in Table B with out affecting other tables related to table A?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Update current records from another table that was imported
- Thread starter xyle
- Start date
You will need to use an update query - either an actual query or called from code.
If you know which records have been changed, just update all records in Table_A with data from Table_B WHERE the record changed=TRUE. Replace all fields except the primary key.
SeeThru
Synergy Connections Ltd - Telemarketing Services
If you know which records have been changed, just update all records in Table_A with data from Table_B WHERE the record changed=TRUE. Replace all fields except the primary key.
SeeThru
Synergy Connections Ltd - Telemarketing Services
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question