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?
ThanksVKKT
Hyperlink issue in MS Access
-
VKKT
- 2StarLounger
- Posts: 184
- Joined: 13 Jun 2018, 07:50
Hyperlink issue in MS Access
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?
Thanks
VKKT
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?
ThanksVKKT
You do not have the required permissions to view the files attached to this post.
-
HansV
- Administrator
- Posts: 78361
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Hyperlink issue in MS Access
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...
Best wishes,
Hans
Hans
-
VKKT
- 2StarLounger
- Posts: 184
- Joined: 13 Jun 2018, 07:50
Re: Hyperlink issue in MS Access
Thanks Mr. Hans for the response
regards,
VKKT
regards,
VKKT