When I import an Excel file containing hyperlinks into Access, the hyperlinks turn into text and no longer hold their links. I am using the TransferSpreadsheet function in Access to import my table. I have done a bit of searching a come across this code: UPDATE tblTest SET tblTest.hyperdocs = "#" & [hyperdocs] & "#"; (where tblTest = name of table and hyperdocs = name of hyperlink field in spreadsheet This is supposed to add pound signs around the hyperlink to make it active. I am having trouble getting this to work and wanted to know if their was a better way to go about it or if someone could instruct me on how I enter this line of code into my database. Thanks.