Help getting web data into excel...

Discussion in 'Data Sets and Feeds' started by H2O, Jan 5, 2007.

  1. H2O


    OK, I've given up...

    This should be really simple:

    LIFFE updates the settlement prices every day on their website, and I would like to get them into an EXCEL sheet.
    (example for todays file)

    If I use the web query, the formatting is all messed up...
    I only need the SETTLEMENT price for all contract months of Euribor to start (I can figure the rest out myself)

    I think the easiest way is to read the entire form in a sheet , and than read the data that I need into another sheet, however, it would be easier if the data would be in separate columns, and that is what I cannot get done...

    Any help?
  2. gem333


    Save the file somewhere on your disk as a txt file.
    Open up Excel.
    Open the file you just saved as a Files of Type: Text Files.
    Text Import Wizard will appear.
    Choose to open as a Fixed width file.
    Press next and finish. That’s all.
  3. H2O


    This will give me the same results as the web query.
    I need to read some data from it, and all the data is parsed into one column (For some reason this file is hard to read)
  4. cashcow


    You can write VB code to open the .txt file as a data source (JET type), and read the data as you would a database.

    This support document from Microsoft explains the process: