Importing hyperlinks from Excel

[Lisa]

I would like to import an Excel spreadsheet into Access database--however,
the spreadsheet contains hyperlinks in two columns. They are web-based links.
I have read the links will NOT import into Access. Indeed, upon trying, the
links import as just text.

Any ideas on how I could import these links along with the other spreadsheet
info into a database? There are over 4,000 records in the spreadsheet and we
really don't want to manually recreate or copy & paste those links!

Thanks, Lisa

 

[Jeff Boyce]

Lisa

You could try importing the (text of the) hyperlinks into Access as "raw"
(temporary) data, then use a query to append the string into a
hyperlink-type data field in a more permanent Access table.

JOPO (just one person's opinion)

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

 

[Lisa]

Thanks for the post Jeff!

Lisa

You could try importing the (text of the) hyperlinks into Access as "raw"
(temporary) data, then use a query to append the string into a
hyperlink-type data field in a more permanent Access table.

JOPO (just one person's opinion)

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

 

[Ron2006]

In a number of applications I have delt with we have decided to leave
it as a string. It is easier to modify by the user. Then when it is
displayed we have a dbl-click event of application.followhyperlink
fieldname.

This works just as well and is easier to modify.

Ron