Import hyperlinks from Excel

[Bill McKay]

I have a massive spreadsheet that contains hyperlinks in most cells. I would like to import these into an access table. All efforts have failed. I can get the displayed text to import, but the hyperlink information does not come accross. Anyone have any insight? Thanks!

 

[Crilen007]

Have to import and change the field type to hyperlink i believe.

 

[Bill McKay]

Hyperlink field type

I've tried to import into a table with a field defined as type hyperlink. No joy. I'm thinking that code will have to be written to specifically access the hyperlink information from Excel during the import process. The problem is I have no clue how to access the hyperlink info from Excel using code.

 

[Crilen007]

Ohhhh. I see what you mean now.


In excel it just has a word, but it has an embedded hyperlink.


I see.

I tried searching MSDN, and also i looked in utter access, with no luck.
Only other people with the same issue.

Good luck, and please post here if you find the answer.

(I will try it later today)

 

[Bill McKay]

I found what I was looking for here:

For what it's worth, I found what I was looking for on this website:

http://www.mvps.org/dmcritchie/excel/buildtoc.htm

Within this site, the "#MakeTextOnlyFromHyperlinks" routine included the code I was looking for. Specifically:

Dim URL as String

URL = cell.Hyperlinks(1).Address

 

[tubbekans]

Importing hyperlinks

I had this problem too. I found out that if I save my Excel file as html that I can then import the html doc and the hyperlinks come in to Access correctly. In my case, I took the spreadsheet that had the hyperlinks into a new Excel file with just that 1 sheet. Then saved it as type html. Get external data imported the html doc as a table with hyperlinks then. I used Access 2000 for this.

 

[zaranne]

OMG!!! This is the answer I have been searching for for MONTHS!!! :banghead:

And it's so very simple too! I needed to get an Excel spreadsheet that is downloaded daily from a web database, get it into Access, preserving the Hyperlinks, so that I could divide these into 60+ individual reports for e-mailing. I was doing all of this by HAND before! My life just got so much easier! Thanks guys! (or gals, as the case may be)...