Hyperlink issue in MS Access

VKKT
2StarLounger
Posts: 176
Joined: 13 Jun 2018, 07:50

Hyperlink issue in MS Access

Post by VKKT »

HI,
Greetings..

I have an issue when copy and paste data from excel (with hyperlink) to access table, the link is not showing in the address but only in the "text to display" area, how to resolve this issue?

:thankyou: Thanks
VKKT
You do not have the required permissions to view the files attached to this post.

User avatar
HansV
Administrator
Posts: 75279
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Hyperlink issue in MS Access

Post by HansV »

Access does not handle this well, as you have found. You'd have to place # before and after the text in Excel. And I don't know if it would work with paths containing spaces...
Regards,
Hans

VKKT
2StarLounger
Posts: 176
Joined: 13 Jun 2018, 07:50

Re: Hyperlink issue in MS Access

Post by VKKT »

Thanks Mr. Hans for the response
regards,
VKKT :thankyou: