Importing hyperlinks

[shannon]

How do you import a hyperlink that shows in Excel into Access? I am
importing/linking from an excel document sheet, but the hyperlink in the
columns is being imported as text and is not accessible once it is the Access
table.

 

[Gina Whipp]

Shannon,

The field to which you are importing is it set Hyperlink?

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

 

[shannon]

Yes, I have an excel sheet that has a column of hyperlinks, all individual
links. I can update them individually to show up in Access, but there has to
be an easier way of importing the information. When I import the excel into
access, the only thing that imports is the name of link. The link is no
longer accessable once it is imported. I tried to update the hyperlink in
access, but it only takes me to the page where its located. I hope this makes
sense. Thank you for your reply.. Best regards!