Results 1 to 7 of 7
  1. #1
    Silver Lounger GARYPSWANSON's Avatar
    Join Date
    Aug 2001
    Location
    Frederick, Maryland, USA
    Posts
    1,788
    Thanks
    0
    Thanked 2 Times in 2 Posts

    Import Hyperlink from Excel (A2003)

    Just had a request to import an excel spreadsheet into Access. The first column of the spreadsheet in a hyperlink that points to PDF files on a network. Is there a way to have the Hyperlink import directly into the Access table such that it doesn't have to be re-input? If so, does the hyperlink import as text?
    Regards,

    Gary
    (It's been a while!)

  2. #2
    5 Star Lounger
    Join Date
    Nov 2004
    Location
    Wilmington, North Carolina, USA
    Posts
    1,196
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Import Hyperlink from Excel (A2003)

    Gary,

    You don't have to re-input, but after you import the excel document, you have to change the field type to hyperlink in the Access table.
    ____________________________
    Jeremy
    "If you spend more on coffee than on IT security, then you will be hacked. What's more, you deserve to be hacked." -Richard Clarke

  3. #3
    Silver Lounger GARYPSWANSON's Avatar
    Join Date
    Aug 2001
    Location
    Frederick, Maryland, USA
    Posts
    1,788
    Thanks
    0
    Thanked 2 Times in 2 Posts

    Re: Import Hyperlink from Excel (A2003)

    Thanks,

    Does the same apply to a table in a word doc?
    Regards,

    Gary
    (It's been a while!)

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Import Hyperlink from Excel (A2003)

    Import the Excel worksheet into a new Access table. The hyperlinks will be imported as plain text.
    Open the imported table in design view and change the text field to a hyperlink field, then save the table. The hyperlinks should work.

  5. #5
    Silver Lounger GARYPSWANSON's Avatar
    Join Date
    Aug 2001
    Location
    Frederick, Maryland, USA
    Posts
    1,788
    Thanks
    0
    Thanked 2 Times in 2 Posts

    Re: Import Hyperlink from Excel (A2003)

    Thanks Hans.

    Does the same apply to importing hyperlinks from a table in a Word Doc?
    Regards,

    Gary
    (It's been a while!)

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Import Hyperlink from Excel (A2003)

    Why don't you try? <img src=/S/smile.gif border=0 alt=smile width=15 height=15>

  7. #7
    Silver Lounger GARYPSWANSON's Avatar
    Join Date
    Aug 2001
    Location
    Frederick, Maryland, USA
    Posts
    1,788
    Thanks
    0
    Thanked 2 Times in 2 Posts

    Re: Import Hyperlink from Excel (A2003)

    Hans,

    Will do. (Sorry for being lazy....) <img src=/S/sorry.gif border=0 alt=sorry width=15 height=15>
    Regards,

    Gary
    (It's been a while!)

Posting Permissions

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