I have a piece of software that will pull specific file information from an entire directory and write it into an excel spreadsheet. When set up as a hyperlink, the resulting [Path]+[FileName] in the excel spreadsheet works perfectly as a hyperlink, retrieving the file (regardless if it's document or image). In Access, I can import this to a table and the hyperlinks remain in-tact. Where I run into problems is when I try to add data from a 2nd (& 3rd & nth) directory, and append it to the original file. The links display but the hyperlink does not. When
