+ Reply to Thread
Results 1 to 2 of 2

Import Data Problem

  1. #1
    Eamon
    Guest

    Import Data Problem

    Hi,



    Data->Import External Data->New Web Query->Options

    and selected Full HTML Formatting, Import <PRE> Blocks into Columns, Treat
    Consecutive delimiters as one, Disable Date Recognition.

    Now when this is imported to the spreadsheet and I click on a hyperlink it
    will not open. What could be preventing this?

    If I copy from the web and past into excel the hyperlinks are working but it
    is changing some numbers to dates how can I prevent it from changing some
    numbers to dates?

    Any suggestions would be much appreciated.



    Eamon



  2. #2
    Eamon
    Guest

    Re: Import Data Problem

    Any suggestions would be much appreciated.

    Eamon

    "Eamon" <[email protected]> wrote in message
    news:[email protected]...
    > Hi,
    >
    >
    >
    > Data->Import External Data->New Web Query->Options
    >
    > and selected Full HTML Formatting, Import <PRE> Blocks into Columns, Treat
    > Consecutive delimiters as one, Disable Date Recognition.
    >
    > Now when this is imported to the spreadsheet and I click on a hyperlink it
    > will not open. What could be preventing this?
    >
    > If I copy from the web and past into excel the hyperlinks are working but
    > it is changing some numbers to dates how can I prevent it from changing
    > some numbers to dates?
    >
    > Any suggestions would be much appreciated.
    >
    >
    >
    > Eamon
    >
    >




+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1