Web Query

[Bradley_99]

Hi,

I am trying to use the Import external data Web Query option. When I choose the table I want from this site and import, I receive the message "the Web query returned no data". The website I am trying to pull data from is, http://octane.nmt.edu/gotech/Petrole...njection=False. Would it be easier to create a macro that can pull the data from the url address? I will greatly appreciate any help from anyone on this subject.

Thanks,

Brad

[dollarsing]

Hi pple

I am also trying to pull out data from the following site using the "From Web" function under Data tab. But its does not recognized the table I am look to draw data from.

Site: http://www.emcsg.com/MarketData/PriceInformation

I like to ask if there is any way I could work around this or do I have to write a VBA for this extraction? I am looking to pull this data every 30mins.

Thank you pple

Cheers
Bryan