How to load data into excel?
 

Does anyone have any suggestions on how to load data into excel?
There is the link for data
http://download.finance.yahoo.com/d/...1c1ohgv&e=.csv

Thanks in advance for any suggestions
Eric

How to load data into excel?
 

Have you tried Data/Import External Data/New Web Query.

You supply the URL and then select the tables from the web page you want to
import.
--
Kevin Backmann


"Eric" wrote:

Does anyone have any suggestions on how to load data into excel?
There is the link for data
http://download.finance.yahoo.com/d/...1c1ohgv&e=.csv

Thanks in advance for any suggestions
Eric

How to load data into excel?
 

When I load following link, it requests for open / save cvs file.
Do you have any suggestions on how to load it without opening or saving any
file?
Thank you very much for any suggestions
Eric

"Kevin B" wrote:

Have you tried Data/Import External Data/New Web Query.

You supply the URL and then select the tables from the web page you want to
import.
--
Kevin Backmann


"Eric" wrote:

Does anyone have any suggestions on how to load data into excel?
There is the link for data
http://download.finance.yahoo.com/d/...1c1ohgv&e=.csv

Thanks in advance for any suggestions
Eric

How to load data into excel?
 

That link is to a *.csv file. not a data table.

You must find an alternate link to get to the source data for the quote.csv
file.


Gord Dibben MS Excel MVP

On Mon, 9 Mar 2009 05:36:00 -0700, Eric
wrote:

Does anyone have any suggestions on how to load data into excel?
There is the link for data
http://download.finance.yahoo.com/d/quotes.csv

Thanks in advance for any suggestions
Eric