paste many hyperlinks

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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.
Click to expand...

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?
 
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.
 
Back
Top