-----Original Message-----
Hi Albert,
I don't know a simple way of doing this and have never had to do it in
real life. It should be possible along these lines, though with luck
someone else will have a much more elegant suggestion:
1) put the custom worksheet functions below into a module. They extract
the hyperlink information from the Excel cells.
2) add a column to a copy of your worksheet, and use a formula like
this:
=GetHyperlinkText(B2)&"#"&GetHyperLinkURL(B2) &"#"&GetHyperlinkSubAddress(B2)
to assemble the bits of hyperlink information into a string in the
format used in Access hyperlink fields.
3) delete the hyperlink column. Select the entire worksheet and do
Edit|Copy, then Edit|Paste Special|Values to replace the formulas with
the actual values.
4) Set up a new table in Access with the correct field names and types
(a hyperlink field in this case).
5) Import to that table.
I have an extensive list of hyperlinks in an excel document (type of index to directory).
I now need to import these into access whilst keeping the actual links active.
Is this possible and how is it done?
All help appreciated
--
John Nurick [Microsoft Access MVP]
Please respond in the newgroup and not by email.
.
