I have a table of about 20.000 records as the following sample except, field3 which is empty.
field1(number) field2(text) field3(hyperlink)
5 rtyhjsrh 5.jpg
9 sthrth 9.jpg
10 ththfg 10.jpg
25 fghdfgh 25.jpg
As I said the field3 is empty.
All the jpg files have the same name as the numbers in the field1.
Is there a way to attach automaticaly the hyperlinks of jpg file in my table in Excel or Access.