Problem with Importing Hyperlink from Excel

[RFabert]

Hello,

I have imported a table with a list of hyperlinks from Excel. When I open the hyperlink editor, it shows the link address in the text field with nothing listed in the address field. Is there a way to transfer the link address in the text field to the address field so that the link will open the browser when clicked? Can I do it without re-importing the entire table?

Thank you!

 

[RFabert]

I am working with Access 2007.

 

[RFabert]

I used concatenate to add # to the front and back of each hyperlink in Excel before importing into Access. It looks like this: concatenate("#",column,"#")

 

[Samantha]

Finally a solution!
I exported my Hyperlinks into Excel from there used the function "Concatenate" inserting the #'s. Imported the new table back into my DB, turned the new fields Data Type back in to a Hyperlink. Like magic it works! Much easier then some other suggestions I was unsuccessful at. Now to just append the data back into my original table.