updating a table via download

  • Thread starter Thread starter suttoh
  • Start date Start date
S

suttoh

Hello,

I'm trying to update a table once a month by importing a
file from another database. I want to capture any
changes to existing records and, of course, all new
records. I keep getting the existing records duplicated
instead of updated. Because the database is relatively
small I have just been deleting the dupes, but obviously
this is not the way I want to do this.

Any suggestions would be greatly appreciated!

Thanks!
 
I haven't done this, but Access has a Replication option built into it that
would be one way to handle this for you. Search for Replication in the help
file to get started.
 
suttoh said:
Hello,

I'm trying to update a table once a month by importing a
file from another database. I want to capture any
changes to existing records and, of course, all new
records. I keep getting the existing records duplicated
instead of updated. Because the database is relatively
small I have just been deleting the dupes, but obviously
this is not the way I want to do this.

Any suggestions would be greatly appreciated!

Thanks!
Click to expand...

Assuming the inported "download table" is separate from the "main" table
(the one you want to update), you could run two action queries, one that
inner-joins the two tables on the primary key field(s) and updates the
main table's fields from the fields in the matching download record;
and one that appends those records from the download table that don't
exist in the main table.
 
Back
Top