How to export from Lotus Notes to MS Access and have links function within Access taking you back to a Notes data page
How do I export from MS Access and the Notes are linked to work in Access takes you back to the page Notes?
Access to copy a table from a linked Notes and work on putting the Excel or Word … but not used at work and then split file Excel hyperlink in Access can be edited manually to work from within. Access, but we have many files to connect to.
Lotus Notes Tutorial:
The format structure for the link in Access needs to follow this pattern:
displaytext#address#subaddress#screentip
Link#Notes:///C22574FD002C1925/Link/0F35ADABFD4E71718625715B006D33BE#
I couldn’t get it to work with a screen tip at the end so left it off and it works. In the Access cell it simply says “Link” but takes me to the full address of the exact document I need.
I understand the “Link” in the middle of the string can be anything but could be used if you have a specific view you want to look at the document in. I don’t need it and have not tried leaving it out altogether.
So…I export my list from Notes to Excel, concatenate the link into a cell as shown and import to Access.
Viewed 10136 times by 3278 viewers
