import hyperlinks into access

G

Guest

I am trying to import an excel file with a column of hyperlinks into Access.
The hyperlinks are embedded in Text. For example Biocarta has a hyperlink to
http://www.biocarta.com/pathfiles/h_alkPathway.asp. When I import this file
into Access and change the column to hyperlink in design view I only get
hyperlink to
Biocarta and not the real hyperlink. Is there anyway to transfer this
information or do I have to type out each hyperlink individually? I also
tried linking the table but I don't see the hyperlinks at all that way.

Thanks for any help.

Toni-Ann Mistretta

Remember when we thought computers would save us time!?
 
G

Guest

Thanks,

I just tried that and it did not work. I either get www.biocarta or
nothing. I tried first just importing to a new table and then changing
column to hyperlink column - www.biocarta

and then I created table with a hyperlink column and imported into it and I
get
"Biocarta" and no hyperlink attached to it.

Am I doing something wrong? (obviously I must be!)

Thanks again for any help
 
G

Guest

Interesting. I had a friend try to import my original Excel file into Access
and it worked for him. He has an earlier version of Access (2002) so it
looks like problem is with Access 2003

Any comments?
 

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
Import Hyperlinks 2
How can I import Excel hyperlinks into Access hyperlink field? 1
Importing Hyperlinks from Excel to Access 3
Importing hyperlinks 2
Importing Excel Data with Hyperlinks 3
Access 2010 Disable Microsoft Access Security Notic 3
import hyperlink from excel to access 1

Top