[AccessD] Import excel web links

[Heenan, Lambert]

That special sauce may be here...

https://social.technet.microsoft.com/Forums/office/en-US/a79d1eec-32cb-44be-95f7-c2645a654a52/import-excel-into-access-and-preserve-hyperlinks


Lambert

-----Original Message-----
From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of John W. Colby
Sent: Sunday, April 19, 2015 9:22 PM
To: Access Developers discussion and problem solving
Subject: [AccessD] Import excel web links

I am trying to import Excel spreadsheets that are a column of links.  
The thing I see is the description of the link, underlying which is a link to the web page.  When I try to import (or link) to the excel spreadsheet, I end up with the description, and lose the link.

Any secret sauce to get both as two columns?

--
John W. Colby

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com