ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Importing Access File with Hyperlink (https://www.excelbanter.com/excel-discussion-misc-queries/24233-importing-access-file-hyperlink.html)

B.C.Lioness

Importing Access File with Hyperlink
 
I have an excel file to determine parts needed and costs for the many
projects we have going on. I have an Access Database table load into a sheet
of the Excel file that contains information of our inventory.
I have just added a hyperlink column to my inventory database so that the
user can click on the link to open the spec sheet of the corresponding part.
My problem is that when I added this hyperlink to the query in Access and
then opened my Excel file, the hyperlink column is there, but has been
converted to plain text.
I can manually change it to hyperlinks, but everytime the data from the
Access file gets updated, it will overwrite my hyperlinks.

Is there a way I can import that column as a hyperlink, or maybe convert
that column to hyperlink after importing/updating the data?



All times are GMT +1. The time now is 01:59 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com