Import / Link Excel cell into Access field?

[CraigBFG]

Can anyone help.....

I'm trying to import/link a single excel cell reference value (Currency) into a specific field in an Access table.

The field must remain uptodate as and when the excel sheet changes, but will also be different for every single database record. I've got the file reference import sorted.

tmyTable
Rec01 - Text goes in here - FileRef - XL cell value in here
Rec02 - Text goes in here - FileRef - Different XL cell value in here.
Rec03 - Text goes in here - FileRef - Different XL cell value in here.
....
Thanks