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

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
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Importing Data from Excel into Access with hyperlinks 3
Importing Hyperlinks from Excel to Access 3
Hyperlinks Export to Excel Errors 1
Cut & Paste in Excel without erasing cell borders? 1
import hyperlinks into access 4
Importing Excel Data with Hyperlinks 3
How can I import Excel hyperlinks into Access hyperlink field? 1
Web Hyperlinks to internal MS Word Hyperlinks 0

Top