Updating tables question

  • Thread starter Thread starter Golfinray
  • Start date Start date
G

Golfinray

I have some data in Excel sheets that is sometimes updated by the users here
at work. I imported the data into Access, made tables out of the data, and
normalized the tables. I don't have the tables linked to the spreadsheets
because they are not the same. I would like to routinely (like every two
weeks) bring any data that has been changed in the spreadsheets into the
database and update the tables. There are only 3 or 4 fields that really need
to be updated in each table. Is that possible?
 
Golfinray,
as linking to the spreadsheet is not an option, you can import all the data
into a halfway table.
From the halfway table use queries to find which data represents new records
and append these to the relevant table.
From the halfway table use queries to find which data represents records
that have been edited and update the relevant tables with the new values.

In 2 weeks time when you want to repeat the process, empty the halfway table
before you repeate the process.

Jeanette Cunningham
 
Thanks so much! One quick question. I can write the queries in the halfway
query to see what files have been updated, no problem. I can write an append
query no problem. My question is how do i append just the files that have
been changed? There is probably an easy way to do that, I'm just not picking
up on it. Can you just append single pieces of data? Thanks Again!
 
To change only part of a record, use an update query instead of an append
query.
Create a query joining both tables on a matching unique field ( aka primary
key or similar)
Change the query to an update query.
Use the criteria row to specify conditions about which rows to update.

Jeanette Cunningham
 
Back
Top