web queries...

[Guest]

What's the deal with these? Are these real queries in the SQL sense?

Example: if I use the Web Query option under Data-->Get External Data does
the wizard generate some SQL in the background to import, say, a stock tabel
from finance.google.com?

It seems to me that it just does a copy and paste. I can do that on my own.

Am I missing something here?

 

[Guest]

I am not that impressed with these either, athlough you can play with the
underlying html data.

see link!
http://www.vertex42.com/News/excel-web-query.html

 

[Franz Verga]

What's the deal with these? Are these real queries in the SQL sense?

Example: if I use the Web Query option under Data-->Get External Data
does the wizard generate some SQL in the background to import, say, a
stock tabel from finance.google.com?

It seems to me that it just does a copy and paste. I can do that on
my own.

Am I missing something here?

Hi Dave,

I think you can find useful informations here:

http://office.microsoft.com/en-gb/assistance/HA010450851033.aspx

http://www.vertex42.com/News/excel-web-query.html

http://www.vertex42.com/ExcelTemplates/excel-stock-quotes.html


--
Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy