Convert Hyperlink field to straight text

[David Logan]

Hello,

I am having to migrate an access database to SQL and one of the fields
is the email address of type Hyperlink. I want to get just the
straight email address and store that in my sql database! Does
anybody have any suggestions?

Thanks

dbl

 

[John Nurick]

Hi David,

If you use a calculated field like this, where Hyper is the name of the
field,

CStr(Hyper) AS sHyper

in a query you'll see the actual contents of the field. Typically this
will be something like:
MAILTO:[email protected]
or
Joe Blow#MAILTO:[email protected]

So all you need to do is use an expression in the calculated field to
dump the MAILTO: and return just the address.