Originally Posted by Yecats131
Okay, so I've ready over the tutorials and Help sites that were provided to me. It looks like a Update Quary only allows you to update information built in.... which doesn't help.
(Replace ___ with ____ if x condition is met)
What I have is a spreadsheet with a list of requisition numbers who's status information needs to be updated.
When I import an excel spreadsheet directly, does it locate the Primary Key (Requisition number) and update the information accordingly?
If you tell it to.
You need to have a condition put on the primary key.
So if it's the Req#, then you just need to have the update query match the Req# from your temporary import table to the main table, then update the status field from the temporary import table.
The query will only change data where the two Req#'s are equal.