Can I cut & paste data containing hyperlinks from Excel to Access?

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

Guest

I have a worksheet in Excel with a list of fields containing hyperlinks to
web addresses. I want to paste this into Access, but if I select more than
one record, the hyperlink does not paste. Is there any way of batch copuing
such data?

As an alternative, I could copy in the list of hyperlinks into a separate
column in my database. However, I don't konw how to show the hyperlinks
rather than the text. Can this be done?

Thanks anyone....
Nick
 
Hi Nick,

If you search Google Groups for
nurick dead excel hyperlink
you'll find one way of doing it.

On Wed, 3 May 2006 08:31:02 -0700, Nick Miller <Nick
 
Back
Top