I think the problem is that link from excel cell is by default transfered to
text type in access and is not the access hyperlink type.

Hyperlink fields in Access (97 and later) are actually just modified text
fields that follow a special format. This format consists of three parts
seperated by # symbols. These three parts are the Display Text, the Address,
and the Sub Address. The Display Text is what you see when you look at the
data in an Access form. The Address is the path to the target document. The
Sub Address is the location within the file or page. This format, and the
fact that the Display Text and Sub Address are optional, is why most data
retreived from these fields simply looks like the URL surrounded by #
symbols.
So if you want to have the link to file C:\test.xls in access, you must have
#C:\test.xls# in the field of access table. Because you are importing the
excel file into access table you should put such #...# format first in excel
and also you should choose hyperlink as the access field type.

Ivan

"MikeF" wrote in message
...


Need to put a hyperlink in a cell, say ax2, with the current drive
letter\path\filename and nothing else.

The hyperlink will be imported into an Access table, and needs to be what
will get me back to this Excel file.

Have tried lots of INFO and CELL formulas, they all *look* like they work,
but don't in Access.
The only thing that works is manually copying the path from the locator
bar,
and that is, well, no fun!

Regards,
- Mike