Update Query???

[Guest]

I have a master table with unique records that I am importing new records
from a table created from an excel spreadsheet. The user can manually enter
data into the master table potentially creating duplicate records when the
new table is imported. If a duplicate record is going to be created I want
the new table's record to "overwrite" the old record.

tblMaster
ID
PONumber
Desc

tblTemp
ID
PONumber
Desc

Any record in tblTemp superceeds any record in tblMaster with the same
PONumber.

 

[Tylee23]

I'm not an expert here but I think when you are importing an excel
spreadsheet it gives you the choice to overwriting existing records. You
also need to make the ID field your primary field and not to allow duplicates.

Tylee23

 

[Jason Lepack]

I'm assuming that you are importing your data from a spreadsheet into
tblTemp and then want to move those records into tblMaster. I applaud
you for designing this in this fashion because it is very easy to use
and one can easily preserve the integrity of their data.

First step is to create an Update Query that will update the records in
tblMaster that match in tblTemp with the new records from tblTemp.
After that you need to create an Append Query that will append all the
records from tblTemp that do not match with any records in tblMaster.

If you need a more detailed description I can give one later.

Cheers,
Jason Lepack