paste many hyperlinks

[Guest]

I am trying to paste many hyperlinks into a table in Access. I have also
tried importing them in a table. Once they are in my access data table they
are not viewed as hyperlinks. When I paste them into a hyperlink column they
do not work either. The links are originally in an excel file and link to
pages on the internet. I have over 15000 links to paste. Is there some how
I can turn them into hyperlinks automatically? I am using office 2000.

 

[Mike Labosh]

I am trying to paste many hyperlinks into a table in Access. I have also

tried importing them in a table. Once they are in my access data table
they
are not viewed as hyperlinks. When I paste them into a hyperlink column
they
do not work either. The links are originally in an excel file and link to
pages on the internet. I have over 15000 links to paste. Is there some
how
I can turn them into hyperlinks automatically? I am using office 2000.

Access 2000 has a "Hyperlink"data type. What about designing your table to
use the Hyperlink data type for that column and then using the Import Wizard
to populate that column from your .xls file?

 

[Guest]

Hi Mike, I tried to do what you said but the link still will not work
because the hyperlink column will not reconize the importet text and/or link
as the actual link. I can select each record and edit manually through the
hyperlink editing option, but I have 15000 records that I need to change.
And maybe later I would have to update them too.