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

N

Nick Miller

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
 
J

John Nurick

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
 
Top