Export a Hyperlink field from Access to Excel

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • Simon

    Export a Hyperlink field from Access to Excel

    Dear reader,



    How to export a hyperlink field from Access to Excel, so it is also working
    in Excel.

    In Excel you have for the Hyperlink to parts:

    a.. Text To Display
    b.. Address
    By simply exporting a hyperlink field to Excel only the "Text To Display"
    part is filled in with the information received from Access.
    The Address part is not showing any information in Excel.

    How to manage to fill-in in Excel the Address part of the Hyperlink field
    with the same information as the "Text To Display" part by export data form
    Access to Excel.



    Thanks for any help.

    Kind regards,

    Simon


Working...