OK
I have resolved this.
I used the Excel text functions to extract the strings and then the
HYPERLINK function to re-create the hyperlink.
A bit long winded (five functions in all!), but it works.
If anyone knows a better way please let me know.
"John Milward" <john.milward[ at ]ipco.co.uk> wrote in message
news:JvmdnQxwLJpIhSjZRVnytw[ at ]bt.com...
[Quoted Text] > Hi
>
> I am trying to export a hyperlink field from an access 2000 database to
> Excel.
> In Access it is fine and the hyperlink works.
> What I get after an export is the name followed by the text of the address
> to link to, but it is no longer a hyperlink.
> I can see no way of formating the cell in Excel to be a hyperlink
> Is there any way to resolve this?
>
> TIA
>
> John
>
>
|