Excel Web Query ...query

[sphenisc]

I'd like to import data from

http://www.rac.co.uk/web/routeplanner/

into Excel

In columns A and B I'd have start town and country; B and D , the finish town and country and in E would be the mileage retrieved from the website.

I've tried playing around with the web query function but don't seem to be getting anywhere.

I've tried this as an iqy file
------
WEB
1
http://www.rac.co.uk/web/routeplanner/
displayscountry="Turkey"&scity="Van"&displaydcountry="Turkey"&dcity="Adana"

Selection=AllTables
Formatting=None
PreFormattedTextToColumns=True
ConsecutiveDelimitersAsOne=True
SingleBlockTextImport=False
DisableDateRecognition=False
----

But nothing useful is returned.


Any suggestions?

I'm using IE 6.0 and Excel 2000

Cheers