Hyperlink sent from access is shown as text in Excel

A

Alu_GK

Hello -
Office 2003, XP.
I have a sheet in Excel that withdraw the information from an access table.
One of the fields is a hyperlink field. in format like this #hlDate#hlPath#
The display should be a date [hlDate], and the [hlPath] holds the path to
the file.

In access its working properly, the hyperlink is active. but when i update
the values in the excel file (using "New Database query" feature) the fieldis
shown as a text field, without any capability of linking the user to the
hyperlink (The link is broken).

Thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Autonumber field in Excel that behaves the same as Access 0
Hyperlink shown as a date field - how to do this ? 6
Active Content in this file is blocked issue 1
Shortcuts in OneDrive 0
Excel does not accept text format! 0
File:// protocol in excel, word - "Hyperlink" redirecting changes 0
Hyperlink Text, Creating With VBA 2
Merging from an Excel file with graphics 1

Top