Web Query HELP!!!

V

Vlad Zelenko

Hi,

I am using Excel 2003 Web Query. I have an ASPX web page that prints a
Database table, and when I enter the URL in the "Data->Import External
Data->Web Query" wizard, the Page displays correctly in the preview pane.
But, when I am done (hit import button), Excel tries to retrieve the data
but fails with the message:

"The 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."

I have not been able to trace the problem.

Any help would be HIGHLY appreciated!

Vlad
 
V

Vlad Zelenko

Bummer!

I found the problem - is it an Excel bug??? - Basically,
in my datasource page the TABLE element was written before the FORM element
and that caused the worksheet to fail on update. The preview window,
however, allowed selection of the table and THAT'S a BUG.

- vz
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Parameter query troubleshooting: Empty cell issue 1
How to create a Web query in Excel? 1
Import external data - web query 3
Database Query Missing 4
Import Data from Access query 8
Data Imports incorrectly 1
MS Query will not start from Excel 2000 17
Excel web query does not import table (from yahoo finance) correct 2

Top