G
Golfinray
I have some data Excel spreadsheets. Deletions, additions, and edits occur in
these Excel sheets almost daily by people in my office. I Don't want to link
the tables because I only want to update a couple of fields. If I import
these into my Access database and split them up with my other tables so they
are normalized, then every week or so I would want to update the data from
the spreadsheets that has been changed in these couple of fields to my tables
so that they are current. Would an update query do that or do I need to use
something else?
these Excel sheets almost daily by people in my office. I Don't want to link
the tables because I only want to update a couple of fields. If I import
these into my Access database and split them up with my other tables so they
are normalized, then every week or so I would want to update the data from
the spreadsheets that has been changed in these couple of fields to my tables
so that they are current. Would an update query do that or do I need to use
something else?