Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Importing Hyperlinks from Excel to Access

Discussion in 'Information Technology' started by Janelle.Dunlap@ge.com, Jul 28, 2006.

  1. Janelle.Dunlap@ge.com

    Expand Collapse

    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.

Share This Page