import hyperlink from excel to access

[DaveMc]

Does anyone know how to import a hyperlink from Excel 2007 into Access 2007?

Example:
An Excel column contains the value Central High, and is defined as a
hyperlink with the address www.CentralHS.org. When I import the spreadsheet
into Access, into a database column that is defined as a hyperlink, it brings
in the value (as text to display), but it drops the URL address.

I've searched the help options, but haven't been able to find anything to
help.

Any help will be appreciated.
Thanks...Dave

 

[Jeanette Cunningham]

Dave,
In A 2003, the same thing happens when you import a hyperlink from Excel to
a hyperlink field in a table in Access.
I imported a hyperlink www.CentralHS.org. . I had to change it to
http://www.CentralHS.org. to make it open the web page when clicked.
I tried this with other web addresses. I found that I needed to put
http:// in front of each web address to make it into a hyperlink that
would open the webpage.

There is a new resource for dealing with hyperlink difficulties on
http://www.allenbrowne.com/func-GoHyperlink.html
This may give you some help with hyperlinks to addresses that are not web
addresses.

Jeanette Cunningham