I have an excel file that I import into access. I have created a temp table to only pull the info I need. The issue I am having is the excel has a hyperlink that I need to use to link to another table (it's a primary key). Since you can't use a hyperling as a link to another table I tried to append the data into another table where the hyperlink would be text. I doing this it listed the text I needed but also the hyperling address. I need to be able to link to this PK.