G Guest Jun 8, 2004 #1 I need to import tables from one access database to another, and overlay that table, but overlay only entries which have changed. Is that possible?
I need to import tables from one access database to another, and overlay that table, but overlay only entries which have changed. Is that possible?
J John Vinson Jun 9, 2004 #2 I need to import tables from one access database to another, and overlay that table, but overlay only entries which have changed. Is that possible? Click to expand... You'll need to *link* to the remote table, and run an Update query. Join the two tables, use criteria to find the records which have changed, and Update the local table fields to [remotetable].[fieldname]
I need to import tables from one access database to another, and overlay that table, but overlay only entries which have changed. Is that possible? Click to expand... You'll need to *link* to the remote table, and run an Update query. Join the two tables, use criteria to find the records which have changed, and Update the local table fields to [remotetable].[fieldname]
