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

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:joe.blow@address.com
or 
	Joe Blow#MAILTO:joe.blow@address.com

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

On 9 Aug 2004 12:15:56 -0700, ibflyfishin@yahoo.com (David Logan) wrote:

>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 [Microsoft Access MVP]

Please respond in the newgroup and not by email.