How Can I Do This?

  • Thread starter Thread starter Santi
  • Start date Start date
S

Santi

Hello,

I have a problem. I basically need to do the following in Access but I can't
seem to find a way. Can anyone give me an idea or direction on how to make
the following scenario happen?

*I have a master table in access where I would like to be able to update the
existing records and add new records if there are any.

Note: I'm using an excel file that I'm importing to access as the source of
my update to my master table.
 
Hello,

I have a problem. I basically need to do the following in Access but I can't
seem to find a way. Can anyone give me an idea or direction on how to make
the following scenario happen?

*I have a master table in access where I would like to be able to update the
existing records and add new records if there are any.

Note: I'm using an excel file that I'm importing to access as the source of
my update to my master table.
Click to expand...

I'd suggest linking to (not importing) the spreadsheet, and running two
queries: an Update query, joining the spreadsheet to the master table by the
unique ID and updating the fields (you can use criteria to restrict updates to
records where there is a difference between the fields); and an Append query,
based on an "Unmatched Query Wizard" query to select only those spreadsheet
records that don't match.

The details will depend on your table structure.
 
Back
Top