Error: This Web query returned no data

[Mike Chamberlain]

Hi all.

I'm having problems importing data from my own ASP.NET web site into
Excel. I create a new Web Query and enter the URL, and my data page
shows OK. I select the table in which I am interested from the window
below, but when I click Import, I get the error message:

"This Web Query returned no data. To modify the query, click OK, click
the name of the external data range in the name box on the formula bar,
and then click Edit Query on the External Data toolbar."

Agh! What is wrong here? How come it can see the data in the dialog
box, but when I come to actually import to the sheet it fails?
Selecting the entire page instead of the single table also makes no
difference.

I have been doing this from an ASP page for a long time now with no
problems. Now I have upgraded the page to ASP.NET it no longer works.
There is no password on the site. I am thinking it could have something
to do with cookies, but I am not sure.

I have seen this support page, but it doesn't help in my case:
http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q277596

Any help very much appreciated.

Mike

 

[Mike Chamberlain]

Thought I'd answer my own question. My ASP.NET page was writing out the
HTML for the table ABOVE the HTML tag. This displays correctly in the
New Web Query window, but obviously causes problems for Excel when it
comes to the import. Moving the HTML output to between the BODY tags
solved the problem.

Mike