I am not a programmer, but I figured a way to hyperlink in excel, but when I exported it into access the links did not work. Now I work with hundred thousand files, the code I wrote in excel was: =HYPERLINK("F:\County\Digital\01445\" &D:D & ".001.tif","Link")
I used this code because 01445...