How to get the URL from the link?

  • Thread starter Thread starter zizou
  • Start date Start date
Z

zizou

Hi,

I have an Excel table with links in one column. I have to convert thi
table into an SQL table but in the SQL table in the link column onl
the "nice name" appears not the full URL.
I'm thinking that in the Excel I should copy the URLs to another colum
and it'd help. I found the =HYPERLINK() function but I'd need th
reverse function.

Can anyone help me?

Thanx,
ZIzo
 
You must log in or register to reply here.

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

Similar Threads

The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Exporting Data From Excel to SQL 1
Convert urls to links 2
VBA - retrieve data on last create named range from previous inserted named range 0
Access stripping decimal places in query 1
Access Dcount (multiple criteria) 3
How to Get Filtered Data from SQL server into Microsoft Excel 2007 5
External data link to Access - no linked tables? 3

Back
Top