Appending data from Excel

[daninthemix]

How do you import data from excel using fields that already exist? In other words, I need Access to append the data to the records rather than try and add it to the recordset and throw a tizzy when duplicates are created.

Thanks....

 

[Sergeant]

If you are talking about updating existing records with new values from XL, then:
Link the spreadsheet as a linked table.
Build an update query that joins the XL table to the Access table.

 

[llkhoutx]

Not an update query, but an append query.