Query Yahoo Finance Quotes

[Dan]

I would like to import the NDX 100 index daily into an access db. The web
query to get at this data in excel format is:

http://ichart.finance.yahoo.com/table.csv?s=^NDX&a=09&b=1&c=1975&d=06&e=7&f=2005&g=d&ignore=.csv

The end date would change daily...What would be the best approach for
gettting this data daily into my access table?

Thanks in advance - Dan

 

[[MVP] S.Clark]

File / Get External Data / Import

You can import straight to the table, or to a different one, then append to
the final table.