Hyperlink Problem

[gumbi17]

I have a main table that I just imported all of my data into, I have 41k separate hyperlinks attached to each of the separate number. The problem is on the excel sheet before I imported they all would open the default browser and pull them up. Once imported they will not open, the field is set to hyperlink, and if I type in a value it will launch a browser and try to go to that link. Is there a setting I am missing when I imported these from Excel as a general field to the access hyperlink field?

 

[David R]

Google is your friend.

http://social.technet.microsoft.com...ort-excel-into-access-and-preserve-hyperlinks may be useful.

 

[gumbi17]

Yes the document I was given in excel had functioning hyperlinks. I wasn't sure if when importing from excel when asked what type of field I already had a hyperlink field to put them into. I also have been playing around and if I delete the last character and then reinput that character it works. So it has to be something with the import.

 

[David R]

Read the link. You need to put a # before and after your hyperlink before importing.

 

[gumbi17]

That worked awesome, thanks I did not know about that!

 

[David R]

It's a totally obscure 'feature'.