Importing hypertext field in Excel 2003

[Sylvia]

Hello everybody
I have a database in Access 2003 in which clients adata are stored.

Of course there is also the e-mail field, a hypertext field where the data
are stored and displayed as mailto:[email protected]

When I export the table in Excel 2003 (File, Export, then choosing Excel
97-2003)
I gett al the data, but the emal field shows in two different ways:
The majority of them is like
#mailto:[email protected]#

while about 20% of the total is
mailto:[email protected]#mailto:[email protected]#

I wonder if somebody has an idea about the reason why it happens. The
databse have been created by importing the data, and then of course updating
them and adding new records.

I'd like, of course, to have the data in the excel field in one format only,
possibly
#mailto:[email protected]#
which is much easier to ahndle in Excel.

Any help?

Thanks in advance

ciao, Sylvia

 

[Douglas J. Steele]

It happens because that's how hyperlink fields are stored in Access!

Rather than export the table, create a query that uses the HyperlinkAddress
part to strip out only the address itself, not the rest of the hyperlink
field, and export the query.

 

[Sylvia]

Thanks Douglas for your answer. So Access stores the hyperlink fileds in this
way. Ok.
The table I am exporting comes itself from a query, let us say all the
companies based in europe.
I am not querying the e-mail filed itself, i am just having it in the results.

Now, I guess, I should add a condition in the e-mail field to get only the
text and not the hyperlink. Corrrect?

What should be this condition?

 

[Douglas J. Steele]

Afraid I don't know what you mean that you're not querying the e-mail field
itsefl, you just have it in the results.