Problems with importing data from WEB
 

Hi

I wonder if anyone can help me with my problem.

I try to make a query from a web page
http://www.rikstoto.no/Program/Default.asp
The problem i have is that i cant get the full info from the page, if i
click on the 'detaljert liste' and try to import it into excel it only
import the short list as it started with.
I have looked on all posibilities, but cant find the solution. And hope that
somebody can help me with my problem.

BR
Nicolay

Problems with importing data from WEB
 

Below is the data I imported. It looks like I got all the data. There were 3
arrows in a row. I selected the bottom arrow to get the data below.
'detaljert liste' was the 1st arrow.


1 Pil Elden V 6 30,8m 29,7al 74 000 34073 7%
2 Branddon V 5 30,1k 29,1ak 62 103 47410 10%
3 Aravinna HP 6 29,7m 34,0am 62 000 85782 18%
4 Skjegge Vilje HP 4 29,8k 30,7am 60 200 26275 5%
5 Tysvær Even V 5 30,8k 29,3ak 67 950 4737 1%
6 Valle Sprinten V 5 31,4k 28,6am 85 500 215781 46%
7 Glimra HP 5 31,0m 30,1ak 72 852 97043 20%
8 Røeds Gnisten V 4 30,8m 30,3ak 65 400 28515 6%
9 Juv Svarten V 6 32,1m 30,3ak 44 000 6296 1%
10 Søndre Prinsen V 4 30,5m 30,6am 71 050 14823 3%
11 Linnrappen V 4 32,0m 28,8ak 66 000 69490 14%
12 Huldre Hilde HP 5 29,0m 28,8ak 116 300 10214 2%
13 Fotlandstjerna HP 4 30,0m 31,0am 124 369 6058 1%
14 Runar V 4 29,8m 30,7al 96 500 26991 5%
15 Pirka V 6 31,0l 29,1am 103 500 5645 1%


"Nicolay Gulliksen" wrote:

Hi

I wonder if anyone can help me with my problem.

I try to make a query from a web page
http://www.rikstoto.no/Program/Default.asp
The problem i have is that i cant get the full info from the page, if i
click on the 'detaljert liste' and try to import it into excel it only
import the short list as it started with.
I have looked on all posibilities, but cant find the solution. And hope that
somebody can help me with my problem.

BR
Nicolay

Problems with importing data from WEB
 

Hi Joel

Thanks for trying. That is the same result i get, but i want to get all the
other 5 lines under 'detaljert liste' also. I dont know if that is
unpossible, looks like it from my pont of view. But if there are someone
that has the knowlege to get all the data from that site (
http://www.rikstoto.no/Program/Default.asp ), I would very much appritiate
of how you do that.

Thanks
Nicolay



"Joel" skrev i melding
...
Below is the data I imported. It looks like I got all the data. There
were 3
arrows in a row. I selected the bottom arrow to get the data below.
'detaljert liste' was the 1st arrow.


1 Pil Elden V 6 30,8m 29,7al 74 000 34073 7%
2 Branddon V 5 30,1k 29,1ak 62 103 47410 10%
3 Aravinna HP 6 29,7m 34,0am 62 000 85782 18%
4 Skjegge Vilje HP 4 29,8k 30,7am 60 200 26275 5%
5 Tysvær Even V 5 30,8k 29,3ak 67 950 4737 1%
6 Valle Sprinten V 5 31,4k 28,6am 85 500 215781 46%
7 Glimra HP 5 31,0m 30,1ak 72 852 97043 20%
8 Røeds Gnisten V 4 30,8m 30,3ak 65 400 28515 6%
9 Juv Svarten V 6 32,1m 30,3ak 44 000 6296 1%
10 Søndre Prinsen V 4 30,5m 30,6am 71 050 14823 3%
11 Linnrappen V 4 32,0m 28,8ak 66 000 69490 14%
12 Huldre Hilde HP 5 29,0m 28,8ak 116 300 10214 2%
13 Fotlandstjerna HP 4 30,0m 31,0am 124 369 6058 1%
14 Runar V 4 29,8m 30,7al 96 500 26991 5%
15 Pirka V 6 31,0l 29,1am 103 500 5645 1%


"Nicolay Gulliksen" wrote:

Hi

I wonder if anyone can help me with my problem.

I try to make a query from a web page
http://www.rikstoto.no/Program/Default.asp
The problem i have is that i cant get the full info from the page, if i
click on the 'detaljert liste' and try to import it into excel it only
import the short list as it started with.
I have looked on all posibilities, but cant find the solution. And hope
that
somebody can help me with my problem.

BR
Nicolay