Importing hyperlinks from excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
Thanks John!

Worked for me!

Greatfully,
Michele
-----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
Click to expand...

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.
.
Click to expand...
 
Back
Top