change a URL into html hyperlink code in access

G

Gareth Clayton

I have imported a title list from excel to an access database table
and would like to know how to
change the imported URL which is long and ugly into html hyperlink
code with the title
name as the actual hyperlink. eg <a href=URL><u>TITLE</u></a>
The title and url are different for each record.
At the end of it all I want to be able to import the database record
(hyperlink) using the database results
component in frontpage to create a searchable linked database of
titles.

This is what I have to work with
URL

http://gateway.proquest.com/openurl...i:pqil:context=title&rft_id=xri:pqd:PMID=7539

and a TITLE field

I have thousands of titles to do any suggestions, Im a bit of a
beginner.
 

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

Top