Appending Data

[oasd]

I'm having difficulty appending data.
I have an import macro (using the Transferspreadsheet function) to import
data from an excel spreadsheet (located in a USB attached to the pc) to an
access database.
The data in the USB has addtional info to be added to the respective record
in the database. The problem is that the data is not appended to the
existing record but merely added as an extra record.....effectively giving
me a duplicate entry with extra info.
How can I append the data relevant to the existing record with no
duplication.
thanks.

 

[Rick B]

When you import it, you need to import it to a NEW table. Then, use an
UPDATE query to update the original table with data from the new table.
Then, delete the NEW table.

 

[oasd]

Do I need a primary key for update queries?
The table i have is tbl_main.
If I simply create a new table called tbl_temp then would I just add both
these tables in a new query (update query) ?
Do I join them up with at join line?
I notice there is a "update" row in the update query (design mode). What do
I enter in this row?