I have created a basic table which has a tblID (Primary Key), Name
(text) & Price (currency).

I need the specific Price field to be linked with the excel sheet, to
the specific data in the price column.

The Excel sheet is set up as:

A B
1 Name Price
2 John £43
3 Simon £56
4 Dave £67

So for the first entry in the Access table John, the price for john
should be linked to B2 in the excel sheet. Instead of typing it in
twice I only need to do it once in excel and then it updates itself in
Access.

Is it possible for Access to update and link these values in a table
or does it require a query?