Table overlay

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
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]
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Windows XP Icon Overlay 0
Overlay two queries into one chart 3
Copying in excel 2
Linked tables missing 1
How do I overlay variable items on an imported image used for a re 19
Overlaying Charts 3
Completely New to Access 6
How can I highlight major occurences in an array? 10

Back
Top