Adding New Field to a Table

[Joe4]

This should be an easy one.

I have a table in Access. I would like to add another field to that table. I have an Excel file that has two fields, the primary key and the field I would like to add to my Access table.

What is the best way of getting the data from the Excel file into my existing Access Table? Can it be imported directly to the exisitng table? Do I need to do some sort of Update query?

No new records will be created by this. All the primary keys in my Excel table already exist in the Access table.

Thanks.

 

[Joe4]

OK, I figured out one way on my own.

I imported my Excel file into Access. Then I did an Update Query, linking the two tables and updated the values in my Original Access table with the value from the field in the other table.

 

[Gregc]

if the data is good, no duplicates and the like in the key field, you can copy the data in Excel and on open the Access table, go to the very left of the table where the little arrow is pointing to the current record and right click and choose paste.