I have a ODBC connection to a MSSQL DB. One of the columns contains a url \\Fileserver\File.
When I import this into excel it is just a string at first, but after I click in the cell and out the cell is converted to a hyperlink.
I know I can use the =HYPERLINK() function, but I want to see if I can avoid that step and just have the cell convert when imported.
Is this possible?
Mike -Yo_Bee- B