Exporting to Excel

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • aaj
    #1

    Exporting to Excel

    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","Cl ick")

    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("ww w.asite.com","C lick") - 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




    Tags: None
    • Ryan
      #2
      Re: Exporting to Excel

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

      "aaj" <a.b@c.com> wrote in message news:<40a8d330$ 0$8090$afc38c87 @news.easynet.c o.uk>...[color=blue]
      > 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","Cl ick")
      >
      > 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("ww w.asite.com","C lick") - 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[/color]

        Comment

        • Terri
          #3
          Re: Exporting to Excel

          >[color=blue]
          > Does anyone know of a way to get rid of the ' thats being added on
          >
          > thanks in advance
          >
          > Andy
          >[/color]
          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....


            Comment

            Previous template Next
            Working...