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 the Hyperlinks properties window is open, only the Text to Display window is populated but the Hyperlink Address is not. Any idea on how to append multiple directories to this Access table?
