Pulling Stock Quotes from the web into Access

[Bwaldin]

Hello Everyone,
I am working on a database which requires financial information and I would love to have access be able to pull down stock quotes from the web(i wish it could pull info from SEC docs as well but I am pretty sure that is out of the question). From some digging I am pretty sure that it can be done using XML, only i am not at all experienced in XML and I have no idea where to begin. Can someone point me in the right direction? If anyone has this function in their database i would really appreciate it if you could share the knowledge. Thanks

Ben

 

[Bwaldin]

I have seen examples using Yahoo Finance to pull the quote info, the code usually looks something like a funny version of HTML(is it xml?) and I have no idea how to integrate it into access so that i can get the info that i need. I have found several examples and they all have different extensions that i am not too familiar with(PHP files, ASP, XSL). Does anyone know a good XML tutorial or somewhere that i can get the background on all of this, at the moment i am lost.

 

[tkpstock]

This place has a section on XML:

http://www.devx.com/projectcool/door/7051

XML is just a way of defining data.