Hi,
I have a database that I update every minute with financial data.
On another machine, a different user will need to get these updates
as
soon as they occur. They will probably be using Excel to do this.
What is the best way to get the data into Excel, bearing in mind that
the Excel machine won't know exactly when the database is updated.
I've been thinking about it, and the only solution I can come up with
is to run a query every few seconds. This is obviously not ideal.
Any suggestions on what I should do would be greatly appreciated.
Thanks,
Enter The.
I have a database that I update every minute with financial data.
On another machine, a different user will need to get these updates
as
soon as they occur. They will probably be using Excel to do this.
What is the best way to get the data into Excel, bearing in mind that
the Excel machine won't know exactly when the database is updated.
I've been thinking about it, and the only solution I can come up with
is to run a query every few seconds. This is obviously not ideal.
Any suggestions on what I should do would be greatly appreciated.
Thanks,
Enter The.