I am importung an Excel spreadsheet with a hyperlink and want to use the
address, not the whole hyperlink. I can copy the cells as an htm document and
then view the source to isolate the addresses, but would prefer some code
which extracts the address as part of (or subsequent to) the importation step.

Assuming that Access recognises the field as a hyperlink, you could create a
query, and type an expression like this into the Field row in query design:
HyperlinkPart([MyField], 2)

Use your field name in place of MyField.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Sandy Shin" <(E-Mail Removed)> wrote in message
news621DA9B-6206-4440-B4C2-(E-Mail Removed)...
>I am importung an Excel spreadsheet with a hyperlink and want to use the
> address, not the whole hyperlink. I can copy the cells as an htm document
> and
> then view the source to isolate the addresses, but would prefer some code
> which extracts the address as part of (or subsequent to) the importation
> step.

Thanks. I did not know of the HyoerLinkPart() function - please note that
HyperlinkPart([myField],2) did not work, but HyperlinkPart[myField]),
acAddress) did

"Allen Browne" wrote:

> Assuming that Access recognises the field as a hyperlink, you could create a
> query, and type an expression like this into the Field row in query design:
> HyperlinkPart([MyField], 2)
>
> Use your field name in place of MyField.
>
> --
> Allen Browne - Microsoft MVP. Perth, Western Australia
> Tips for Access users - http://allenbrowne.com/tips.html
> Reply to group, rather than allenbrowne at mvps dot org.
>
> "Sandy Shin" <(E-Mail Removed)> wrote in message
> news621DA9B-6206-4440-B4C2-(E-Mail Removed)...
> >I am importung an Excel spreadsheet with a hyperlink and want to use the
> > address, not the whole hyperlink. I can copy the cells as an htm document
> > and
> > then view the source to isolate the addresses, but would prefer some code
> > which extracts the address as part of (or subsequent to) the importation
> > step.
>
>