hyperlink problem

message from Aaron on 10 May 2004
I need to import an Excel spreadsheet that has fields
storing hyperlinks. How do I retain the path so that they
will open from Access. I had a problem in the past where
the path was no longer recognized and I'm not sure what I
did wrong.
 
Lynn Trapp replied to Aaron on 10 May 2004
After you import the spreadsheet, open the table in design view and change
the datatype of the field from text to hyperlink.
 

Archived message: hyperlink problem (Microsoft Access Error Message)