Hyperlink not opening after import

[Walter]

I am importing some external data into a table. One field
is of type Hyperlink for which the paths are correct and
it appears to be a hyperlink (i.e. underlined blue font.)
However the hyperlink is not opened upon clicking the
value in the table. This is what i am doing.....

1) I have a .bat file of the following

Dir "D:\test\*.*" /S/B > "D:\Spec.txt"

Which is what I want to get the file path.

Next I want to import the text file into a table. I have
created a specification where the path imports to a field
whose datatype is hyperlink.

All appears ok but does not work.


2)
I also imported the data into a table of type text. If I
then convert to hyperlink, visually I get the same result
and the link works.

Why does 1) not work and 2) does? Am using Office2000 SP3

Regards,

Walter

 

[John Nurick]

Hi Walter,

Cutting a long story short, the URL in the hyperlink field needs to be
delimited with #..#. AFAIR this is done automatically and invisibly when
you edit the field or change the field type from text to hyperlink, but
not when you import from a text file.

Things should work OK if you run an update query to add the hash signs.
Anything before the first hash sign will be interpreted as text to
display in the field, in place of the entire URL.