Copying Excel Hyperlinks into Access

[jwa76]

Hi:

I am a new user of this forum (and it looks great, by the way). I have searched the site for information on hyperlinks as stated in the Title, but haven't found what I am looking for.

I have a large list of hyperlinks (to the Web) in an Excel spreadsheet. I simply want to copy these links into my Access table, but nothing I have tried works. It will give me the hyperlink format, but the link is non-existent. What do I need to do to simply copy the list over to a column in my Access table and preserve the original hyperlinks to the Web? I am experienced in VBA within Excel, but not Access.

Thanks for any help,

jwa76

 

[Hayley Baxter]

Import the excel spreadsheet containing your hyperlinks either to a new table or an existing table in access and change the data type to hyperlink.

 

[jwa76]

Tried that, but it doesn't seem to work...

Thanks for the response, but I couldn't get it to work. All it does is put in an "http://" in front of the label I have for the hyperlink. For example, if the link in Excel looks like this (with the blue color and underline):

49-009-22956

with a hyperlink to a specific website, then when I import it to Access and change the column to hyperlink data type, and run the mouse over it, it shows up as:

http://49-009-22956

and the original link is gone.

Appreciate any other thoughts.

Thanks,
jwa76

 

[Ron_dK]

I have tried to import a spreadsheet ( which included hyperlinks) to access
and once in access it didn't work.
As an alternative, I have copied the hyperlink direct from the internet
into the access table. Ensure that the field data type is set to : hyperlink
et voila.
You might try that.

 

[jwa76]

Works, but still need something more automated...

Yes, I have done that, and it does work. The problem is that I have over 46,000 of them to do...! and was hoping to find something that would do it automatically. Any other suggestions?

Thanks,
jwa76

 

[nevada]

I know this is a long forgotten thread but a few minutes ago I whish there had been an answer to this problem. So now that I found out how to do it I'll just post it.

Basicly you can't (o I couldn't) just cut and paste the hyperlink from Excell to an Access table eventhough the type of the field is set to hyperlink. If you try to it'll create a hyperlink but the address is empty.

So I found that in order for it to work you don't really need an hyperlink but all the data in text format Excell and format it this way:
displaytext#address#subaddress#screentip
and when you paste in the line above it'll automatically create a hyperlink, that is if your field is defined as an hyperlink.