Exporting to Excel

[aaj]

Hi

I am using the DTS package with SQL SERVER 2000. I have a table, and in one
of the columns are links to websites. I am trying to export this to Excel
2002 SP3

a typical text string stored in the table is

=HYPERLINK("www.asite.com","Click")

I had hoped the field would be transferred exactly as is and so would appear
as a hyper link in the Excel document it creates. Unfortunateld it seems to
automatically put a ' in front of it so if I click on the cell, in the bar
at the top I get

'=HYPERLINK("www.asite.com","Click") - Notice the apostrophe

so the full text is displayed in the spreadsheet (rather than the word
Click)

Does anyone know of a way to get rid of the ' thats being added on

thanks in advance

Andy

[Ryan]

That's how Excel stores text strings that begin with =. It's how it
seperates it from an expression.

"aaj" <a.*@c.com> wrote in message news:<40**********************@news.easynet.co.uk> ...

Hi

I am using the DTS package with SQL SERVER 2000. I have a table, and in one
of the columns are links to websites. I am trying to export this to Excel
2002 SP3

a typical text string stored in the table is

=HYPERLINK("www.asite.com","Click")

I had hoped the field would be transferred exactly as is and so would appear
as a hyper link in the Excel document it creates. Unfortunateld it seems to
automatically put a ' in front of it so if I click on the cell, in the bar
at the top I get

'=HYPERLINK("www.asite.com","Click") - Notice the apostrophe

so the full text is displayed in the spreadsheet (rather than the word
Click)

Does anyone know of a way to get rid of the ' thats being added on

thanks in advance

Andy

[Terri]

>

Does anyone know of a way to get rid of the ' thats being added on

thanks in advance

Andy

If you can't find a solution from by modifying the DTS package you could
write a VBA macro in the Excel document that will run when the excel
document is opened and modify the contents of a particulur column
accordingly....