RE: Excel + ADO + INSERT HYPERLINKS

From: Kent Prokopy (KentProkopy_at_discussions.microsoft.com)
Date: 02/17/05 

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

Try using three single quotes on both sides...

Insert into [Sheet1$] (Col1, HYPERLINKCOL)
values(0,'''=hyperlink("\somefile.xls")'''

"Jose Samson" wrote:

> 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.
>