Web Query stops at < character

[Guest]

I'm using Excel 2000, trying to import a preformatted table into excel.

The problem is that the query only imports the table up to a line that
contains a "<" character. All data after the < does not appear in excel.

Has anyone else come across this problem before? Is it possible to fix this
without having to change the webpage and remove the "<" ?

The webpage I'm trying to import from is not a public page, but I have
published a sample page which exhibits the same problem during importing, at
http://mylancerpage.tripod.com (import table number 4, to avoid importing the
ads).

 

[Puppet_Sock]

I'm using Excel 2000, trying to import a preformatted table into excel.

The problem is that the query only imports the table up to a line that
contains a "<" character. All data after the < does not appear in excel.

Has anyone else come across this problem before? Is it possible to fix this
without having to change the webpage and remove the "<" ?

The webpage I'm trying to import from is not a public page, but I have
published a sample page which exhibits the same problem during importing, at
http://mylancerpage.tripod.com (import table number 4, to avoid importing the
ads).

I experienced this kind of problem (though not this specific one).
I was having problems with things not being in the right columns
of a table I was grabbing, because some times cells were empty
or contained weird text or just a 0 or some such. I never did find
a way to force Excel to put things where I wanted, and also had
no influence over the web page (even though the company that
hired me to write this app was the only paying client of that web
page) so the problem never got solved. Eventually I had to do a
lot of coding to accomplish a work-around by fetching the data
from an alternate source.

It was highly frustrating because I could open the page in the
web browser no problem. The table was there, every cell,
exactly as expected. But when I pulled it in through a web
querry, it would drop cells, shift stuff over, etc. though it was
pretty exciting some times, as it found its first way-to-fail
on the day things switched to daylight savings, and it found
another on the day things switched back, and other rare
events.

I'd be pleased to see a summary of anything you may find out.
Socks

 

[Guest]

Well, I've found a very crude alternate way to do it. With data -> external
data -> import text file, I can import the HTML file and it doesn't stop at
the "<" character. Only drawback is it imports all the HTML code too (about
253 lines if you import the tripod webpage), but I'll just put code in to
remove that I guess.

Because I'm importing preformatted tables, Excel was trying to put things in
columns and making a big mess of it all, so I just unchecked the 'import pre
blocks into columns' box to make it all import into the first column and that
worked a lot better for what I wanted.