I am trying to somehow get real-time (or slightly delayed) stock quotes into an MS Access Database. Working in the financial industry, we often make our own tools for different types of stock analysis. These tools are usually in Excel and therefore we just use the MSN Stock Quote Add-In for Excel. This is sufficient for our purposes.
Since I am building an analysis tool in MS Access now, I am trying to resolve the best method for getting some real-time (or slightly delayed) stock quotes into an MS Access database. I have some ideas, such as using Excel with MSN Stock Quotes and then importing this data into an Access table (kind of cumbersome and may need to happen multiple times throughout the day - plus, I don't really want to involve another tool like Excel at all if I can help it)
Does anyone have any knowledge of an MSN Stock Quote type Add-In for MS Access or any other suggestions for how I might accomplish this task? I always appreciate all of the help and excellent suggestions from the folks on this site and I'm hoping someone else may have tackled this same problem, previously.