Results 1 to 3 of 3
  1. #1
    Super Moderator RetiredGeek's Avatar
    Join Date
    Mar 2004
    Location
    Manning, South Carolina
    Posts
    9,434
    Thanks
    372
    Thanked 1,457 Times in 1,326 Posts

    Importing HyperLinks from Excel to Access 2003

    Hello All,

    I have a spreadsheet with 100 entries.
    Each entry has:
    Hyperlinks.JPG

    1. ID # {Key in Access}
    2. OwnerID {Foreign Key in Access}
    3. Tax Parcel No {HyperLink in Excel that when clicked brings up the County Public Tax Records for that Parcel No}.

    When I link this .xls file to Access and then use the table in an Append Query to an existing data table the records are included, the Parcel No shows up in it's field, blue & underlined, however the link does not work. If I edit the link the "Display Text" is there but the Address: is not!
    AccessHLinks.JPG
    What am I missing here?
    May the Forces of good computing be with you!

    RG

    PowerShell & VBA Rule!

    My Systems: Desktop Specs
    Laptop Specs

  2. #2
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts
    I don't think you are missing anything. A search reveals that many peoiple have had this problem.

    Does the suggestion in this post help?
    Regards
    John



  3. #3
    Super Moderator RetiredGeek's Avatar
    Join Date
    Mar 2004
    Location
    Manning, South Carolina
    Posts
    9,434
    Thanks
    372
    Thanked 1,457 Times in 1,326 Posts
    John,

    Thanks for the reply. I loaded the UDF into my Excel workbook and added a column Named it the same as the original column then changed header for original column. Then I filled the new column with =ExpandHyperlink(D2) and copied down. Unfortunately when I went back to Access, deleted the old imported records and reran the Append query I received a Numeric field overflow message.

    Update: John, sorry I didn't read the comments in the UDF. It has to be imported into an Access Text field then converted to a Hyperlink field. I'll give this a try when I can find the time. Thanks again.
    Last edited by RetiredGeek; 2012-02-15 at 18:51.
    May the Forces of good computing be with you!

    RG

    PowerShell & VBA Rule!

    My Systems: Desktop Specs
    Laptop Specs

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •