Excel and ODBC links to Sage Line 50

Can I write a formula in Excel that uses my ODBC link to lookup info in the Sage database?

We use odbc to extract stock quantities etc from Sage into an Excel spreadsheet. Works well except that to get up-to-date quantities it has to be refreshed whenever Sage is changed.

A formula using odbc from Excel direct to Sage might be dynamically updated and remove the need to refresh - but is that possible?
Richard Middleton

Comments
There are 3 comments. Login or register to view them.

thanks Mike

rmiddleton |

Refresh every 60 seconds

mikerees |

Auto refresh

mikerees |