Excel Hyperlinks to Access

[DataGraham]

Hi all

I'm new to Access 2010.

I've a Excel 2007 wookbook called "Meetings2011" which has a Worksheet called "MeetingsUpdater". It has 4 columns A,B,C,D.
Date,Results1,Results2,Results3

In Columns B, C, D, some are cells are just text most have Hyperlinks to Webpages, which have a "Text to Display and an Address". I
cannot get these Hyperlinks to work in Access. I would like to Import this Worksheet form Access and just be able click and it opens
the webpages, and also a way to update the database when new data is added to the Worksheet, which I will cleared for new data.

Using Excel 2007 and Access 2010

Any help appreciated

Thanks

Graham

 

[dnlbrky]

Create a named range for the data in Excel (http: //w w w .contextures.com/xlnames01.html), and then close the workbook. In Access, click on External Data and then Excel (in the Import & Link section on the left). In the window that comes up, browse to the Excel file, and make sure you select the last option (Link to the data source by creating a linked table). Choose the named range, and follow the rest of the wizard prompts. Now whenever you update the Excel file, the Access table will be updated as well. (If you change the location of the Excel file, you'll have to relink to it in Access.)

Do you have an example of a hyperlink value as it shows up in Access that does not work? I created a table with a record of "http: //w w w .google.com" (without the spaces), opened the table, clicked on the link, and it opened in my browser correctly. Maybe you have extra text or it's not formatted correctly somehow?

 

[DataGraham]

Hi dnlbrky

I tried your suggestion and that didn’t work for me.

I've decided to use the Hlink function:

Function HLink(rng As Range) As String
'posted by Rick Rothstein
If rng(1).Hyperlinks.Count Then
HLink = rng.Hyperlinks(1).Address
End If
End Function

Then insert # character at the beginning and end of the URL. That works.

I’ve tried various ways, you would think this day and age of Microsoft Applications that this would be a simple task. Maybe in the future.

Thanks for your help.

All the best

DataGraham