Forums

General Betting

Welcome to Live View – Take the tour to learn more
Start Tour
There is currently 1 person viewing this thread.
Roman.Totale
29 Mar 10 15:11
Joined:
Date Joined: 07 Nov 08
| Topic/replies: 680 | Blogger: Roman.Totale's blog
I'm trying to import some old data for Norwegian soccer from the following web page

http://www.nifs.no/kamper.php?land=1&t=5&u=5696

I go through the normal procedure - the webpage defaults with the fixtures for 2010

In the import webdata window - I change the drop down menu so it's showing fixtures for the 2000 season, highlight the tick marker above that block of webdata and select import, however it ignores the 2000 data and still imports the 2010 data.

Can anyone try this and find away around it.

Thanks in advance.
Pause Switch to Standard View Excel Import problem
Show More
Loading...
Report SM March 29, 2010 3:36 PM BST
You could copy and paste special into excel. May need to format one of the columns so it doesn't read scores as dates.
Report CurlyBlues March 29, 2010 4:06 PM BST
paste special copies it perfectly
Report Roman.Totale March 29, 2010 4:58 PM BST
Cheers, i'll try that.
Report Roman.Totale March 29, 2010 5:08 PM BST
The only problem is before the scores and the home team's name i'm getting a symbol that i can't remove, it's a small box with a question mark in it.

I've tried pasting it into edit, find, remove and it won't paste. Any advice?
Report CurlyBlues March 29, 2010 5:22 PM BST
Not really sure of the problem you're having unless you're not using Office 2007.

The table copies perfectly into notepad for myself. Sorry I can't be more helpful.
Report SM March 29, 2010 7:07 PM BST
Try c and p ing from firefox (if you're not already). Seems to work for me.
Report Roman.Totale March 29, 2010 8:32 PM BST
Okay cheers

I'll try notepad.
Report CurlyBlues March 29, 2010 9:06 PM BST
If it helps I was copying from Chrome.
Report Roman.Totale March 30, 2010 1:35 AM BST
Pasting from Chrome into Notepad and then into excel worked a treat.

Pasting into excel was working in 2007 (at home) but I still had an issue of the scores appearing as dates.

thanks all.
Post Your Reply
<CTRL+Enter> to submit
Please login to post a reply.

Wonder

Instance ID: 13539
www.betfair.com