In Access, be sure the column you are pasting into has been created with:

Insert Hyperlink Column
--
Gary''s Student - gsnu200777


"DaveM" wrote:

Hi

In Access 2002 I formatted Column A to accepted hyperlinks, I then imported
from excel column A which have links to html files on my harddrive.

example

cell A1 showing 0001 with hyperlink that works and opens this
C:\COMMENTS\0001.html

When imported to access the cell when clicked does not open the file?

Is there a way to do this

Thanks in advance

DaveM