I have one column that has product codes

I have another column where I have to add the same product codes plus a reference to
images that match the product codes

How can I automate this so I do not have to physically type in the path to the images?


e.g

ProductCode - 12345 ----> already in spreadsheet
ImageSmall - ../products/images/12345.jpg ---------> I need to type this


I then convert the spreadsheet to Access.


Thanks for any help!