Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Import Data -- External Web Query
I'm trying to grab the table of CD rates at this website --
http://home.ingdirect.com/products/p...asp?s=OrangeCD I can select the table with the external web query, but when it drops the data into Excel the APY and Effective Date are not populated. Looking at the source code it looks like the page is grabbing a string of predefined values. Is there an easy fix to this so that I can have a web query that upon a refresh grabs this table? Have a good day, Ted |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Import Data -- External Web Query
Ted
Tried all the settings in all versions from XP to 2007 and those two columns don't appear, I wonder if they are JavaScript which is calculated on the client or similar but take confirmation that I've tried all formatting options ,etc and opening whole page in Excel but the two columns are missing -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS www.nickhodge.co.uk "Ted Metro" wrote in message ... I'm trying to grab the table of CD rates at this website -- http://home.ingdirect.com/products/p...asp?s=OrangeCD I can select the table with the external web query, but when it drops the data into Excel the APY and Effective Date are not populated. Looking at the source code it looks like the page is grabbing a string of predefined values. Is there an easy fix to this so that I can have a web query that upon a refresh grabs this table? Have a good day, Ted |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Import External Data | Excel Discussion (Misc queries) | |||
How to do Edit Query from Import External Data. | Excel Discussion (Misc queries) | |||
Import External Data/New WEB Query | Excel Discussion (Misc queries) | |||
import external data | Excel Discussion (Misc queries) | |||
Import External Data | Excel Worksheet Functions |