Hi Andrew,
If you are importing data that includes one or more fields containing
URLs, just import the field or fields to an Access Hyperlink field (or
import to a text field and then change the field type).
If you have text data that includes hyperlinks, it's not so simple.
Access text and memo fields normally just store plain text, so they
can't contain hyperlinks (although of course the text can include URLs).
If you must have hyperlinks in text you'll need to store formatted text
(in a memo or OLE field) and display it with an Activex control that can
understand and activate the hyperlinks.
Is there a way that I can import a file with hyperlinks
(i.e., Excel or HTML file) and keep the hyperlinks?
Thanks.
Andrew
John Nurick [Microsoft Access MVP]
Please respond in the newgroup and not by email.
