Excel + ADO + INSERT HYPERLINKS

From: Jose Samson (noemailaddy_at_nowhere.com)
Date: 02/17/05

Date: Thu, 17 Feb 2005 12:04:34 -0800

Hi,

I want to insert a hyperlink into a new excel spread*** using ADO.

Is this possible, all of the data is inserted however it always has a '
in front of it so it does not work.

I create the table like so.
Insert into [Sheet1$] (Col1, HYPERLINKCOL) values(
0,'=hyperlink("\somefile.xls")'

of course the excel file has the values.

Col1, HYPERLINKCOL

1 =hyperlink("\somefile.xls")

But at top it shows

1 '=hyperlink("\somefile.xls")

Is there a way to get rid of the '?

Thanks for your insight.