I just tried dumping a SQL SELECT cursor to Excel where I added a column with a URL like so:

SELECT Vis_PK, Vis_Status, Vis_Start_Date, Vis_Intrastate, Opr_Short_Name, ;
    PADR("http://myDomain.com/xdb/Vis" + TRANSFORM(Vis_PK) + ".xdb", 60) AS URL ;
 FROM visit JOIN operator ON vis_opr_fk = opr_pk ;
 WHERE vis_comprehensive = .T. and ;
  Vis_Type = "Inspection" and ;
  Vis_Status IN ("Completed", "Finalized") AND ;
  vis_inactive = .f. and opr_inactive = .f. ;
ORDER BY vis_Intrastate, vis_start_date

COPY TO "completed_inspection_list.xls" TYPE xls

I found it interesting that the URL column did not display in blue or become clickable in Excel. If I edit one of the values, or manually type something that "looks like a URI" it does. Is there a secret to convincing Excel to treat that column as hyperlinks?

Thanks!