I've got an excel document which gets information from several different sources using RTD sources such as Bloomberg. I'm running various formulas against the data I get and end up with several different result totals. Those totals are ever changing, pretty much ever second some source information changes and the totals update. Works like a charm.

However, I now have to graph that value which changes every second. Also, I need to store that value so that I can go back and get a historical graph. Because of that I actually want to grab said value and just put it into a database I can use in the future.

Now, I've tried using ADODB connection to SQL with a VBA script that reads and pulls the data into a database on an interval. It works however it "blocks" excel while it's doing it's thing so you end up with hourglasses and the effect of excel "hanging" while it's doing it's thing. Since I want to snag the data every second that's not a good thing.

I've also tried using a simple C# DDE program but it's file based so it only pulls what has been stored in the file.

So, summary request, how can I take a dynamically changing value(s) and pump it into a database without Excel getting unusable.