Dynamic URL for first column of data from excel query?


E

Edgeline

I am using the database query to suck four columns of data from an sql
server express 2005 database and it works great.

However, I would like to automatically construct a URL hyperlink for
the 2nd column of data coming into the worksheet from the database
query.

Is there is simple one to dynamically do this?

Any specific feedback would be very much appreciated.

Columns:
ID
Boat Name
Price

Data:
Ocean Speed 100k
Sea Lion 300k

Goal:

<a href="www.mysite.com" + ID> + Boat Name + </a.

Jason
 
Ad

Advertisements


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