Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 9,101
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Importing into excel PROBLEMS [email protected] Excel Worksheet Functions 1 January 11th 08 03:01 PM
Importing problems remondrop Excel Discussion (Misc queries) 3 May 25th 07 08:16 PM
Problems with Importing a File Mystrunner Excel Programming 1 July 28th 06 01:46 AM
Formatting datetime problems importing data from mysql db PEA Excel Discussion (Misc queries) 2 February 23rd 06 11:04 PM
printing/importing problems Steve Excel Programming 3 April 28th 04 07:17 PM


All times are GMT +1. The time now is 04:26 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"