Data connection from web / web query returns code instead of selected data table

[jdrunbike]

Hello,

A web query I am trying to use to bring an online data table into my worksheet is broken. Now, instead of returning the data table nicely into my worksheet, it imports the code of the webpage, instead, and turns my worksheet into a mess.

The query used to work but there was recently an "upgrade" to the program that populates the web table and the query no longer works and just returns the code for the page, instead. I can see the html code for the table in all of the code it returns but I really need the table to import cleanly into excel.

I can't talk to the people who changed the web program. Any suggestions on what I can try on my end?

Thanks!

[newdoverman]

You are at the mercy of the people that own the web site and there is little that you can do about it.

[jdrunbike]

I was afraid of that. It's strange, though, the page and tables look the same from before the upgrade. Also, my workbook imports three sets of tables from the same site and one set works, the other two, even though the look the same, return the mess of code instead of the properly formatted table.

Any idea of what would cause this? I may be able to get in touch with website people.

[newdoverman]

There could be many different things that is preventing you to make successful links. Who knows, maybe they are using a different method to produce the tables and Excel doesn't understand what it is receiving. Maybe the name assigned to the table has been re-assigned to some other table.

If this is an independent web site, don't expect much co-operation.