Importing Excel file with hyperlinks

[gem28]

Hi!

I have been importing an MS Excel file to Access. One of the columns in the Excel file has hyperlinks but whenever I import the file to Access, the hyperlinks gets removed even if I format the textbox in the form with "enabled" hypelink.

Is it possible for me to retain the hyperlinks whenever i import the file to MS Access? Pleas help, pretty please.

Thanks and more power.

gem

 

[MacCaillean]

Hi Gem

If the hyperlinks in the Excel file are displaying the actual path, i.e. what is displayed is

http://websitename/pagename

, set the destination Access form field's Is Hyperlink property to Yes.

Hope this helps

Mac