hyperlinks from excel to access

[hoda64]

Hello,

I am trying to import hyperlinks. Apparently it is not possible to import hyperlinks from excel to access with just the normal wizard. I have tried different techniques such as saving the excel file as a tab delimited file or adding # signs to the fields prior to import to access. The problem is that the links are behind a word. For example the field could have the word "google" and that would direct you to www.google.com. I think in order for the # signs to work, in excel it would have to be #www.google.com#, except for me it imports as #google#. That is just an example to illustrate my issue. In reality there will be a number such as 00010122009 and that number will link to a website.

Is there any way that I could get the hyperlinks that are behind those words to transfer as hyperlinks instead of text?

Thanks in advance...

 

[vbaInet]

Extract the hyperlink from the cell into a new cell before importing. Here's a video on how:

http://www.youtube.com/watch?v=Yx95dbat9ok

Once you've done that. Create a field in your table in Access and set its Datatype to Hyperlink. This is the field you will use for the URL.