Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Importing into excel PROBLEMS | Excel Worksheet Functions | |||
Importing problems | Excel Discussion (Misc queries) | |||
Problems with Importing a File | Excel Programming | |||
Formatting datetime problems importing data from mysql db | Excel Discussion (Misc queries) | |||
printing/importing problems | Excel Programming |