Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi,
I´m trying to run a query to import some data from the web. The problem is that the url from the page doesnt work with the query. The data is displayed in the web as a table , generated by hitting an "OK" button. The problem is that the url from the generated table(page) seems to be some generic address. You can´t load the table just by writing the url on the IE. You have to go to a page, hit the "OK" button and then you´re taken to the table. Can anyone help me? the pages are these : http://www.sidra.ibge.gov.br/bda/ta...t&o=5&i=P&c=655 and after pressing the ok you get to that one, wich is the one containing the data I´m looking for : http://www.sidra.ibge.gov.br/bda/ta...asp?z=t&o=5&i=P if you use this last address directly as an url an error message shows up. thanks very much. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Convert hard coded query criteria to Parameter Query | Excel Discussion (Misc queries) | |||
Excel 2007 / MS Query - editing existing query to another sheet | Excel Discussion (Misc queries) | |||
Save data retreived from query without saving query | Excel Discussion (Misc queries) | |||
Anyone Else Use Database Query to Query Another Sheet in the Same Excel Workbook? | Excel Discussion (Misc queries) | |||
How to use a Access Query that as a parameter into Excel database query | Excel Discussion (Misc queries) |