Importing Hyperlinks from Excel to Access

[Janelle.Dunlap]

When I import an Excel file containing hyperlinks into Access, the
hyperlinks turn into text and no longer hold their links. I am using
the TransferSpreadsheet function in Access to import my table. I have
done a bit of searching a come across this code:

UPDATE tblTest SET tblTest.hyperdocs = "#" & [hyperdocs] & "#";
(where tblTest = name of table and hyperdocs = name of hyperlink
field in spreadsheet

This is supposed to add pound signs around the hyperlink to make it
active. I am having trouble getting this to work and wanted to know if
their was a better way to go about it or if someone could instruct me
on how I enter this line of code into my database. Thanks.

[MGFoster]

Ja************@ge.com wrote:

When I import an Excel file containing hyperlinks into Access, the
hyperlinks turn into text and no longer hold their links. I am using
the TransferSpreadsheet function in Access to import my table. I have
done a bit of searching a come across this code:

UPDATE tblTest SET tblTest.hyperdocs = "#" & [hyperdocs] & "#";
(where tblTest = name of table and hyperdocs = name of hyperlink
field in spreadsheet

This is supposed to add pound signs around the hyperlink to make it
active. I am having trouble getting this to work and wanted to know if
their was a better way to go about it or if someone could instruct me
on how I enter this line of code into my database. Thanks.

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

The target column in the target table has to have the data type of
Hyperlink. If you are making a new table with the imported Excel file,
the default data type for an Excel hyperlink field is Text. You'll have
to change the column's data type after importing the Excel data.
--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBRGOJRIechKqOuFEgEQJTegCg/DE0p2HfhlWC+Zg6uyMibkjXPGAAoOKC
CBBJqb7OVsdptKz7DZtRt6qy
=4OxF
-----END PGP SIGNATURE-----

[Janelle.Dunlap]

Thanks for the reply. I have tried changing the data type for the
column from text to hyperlink, but this only makes the data appear as a
hyperlink (underlined and blue). The actual file path is no longer
linked with it once the import takes place. Any other suggestions?

[MGFoster]

Ja************@ge.com wrote:

Thanks for the reply. I have tried changing the data type for the
column from text to hyperlink, but this only makes the data appear as a
hyperlink (underlined and blue). The actual file path is no longer
linked with it once the import takes place. Any other suggestions?

If it's underlined & blue, that means its a hyperlink & if you click on
it it should take you to the file/document/<whatever>. So, what is this
hyperlink point to?
--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

[Janelle.Dunlap]

The hyperlink should point to a document on a drive on my computer.
However once the table is imported the link is broken so when I click
to open it I get a message box that tells me that it is unable to open
the document.