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
Replies (3)
Please login or register to join the discussion.
Refresh every 60 seconds
Richard
Refresh every 60 seconds is about as dynamic as it can get!
Mike.
Auto refresh
Richard
This solution does not rely on formula, but enabling the autofresh in Excel.
This will ensure the data is refreshed automatically, rather than having to manually remember to do it.
Use the Data menu
Then in Excel XP - Import external Data
or in Excel 2000 - Get External Data
Then Click Data Range Properties
You can then enable either/or the following options -
Background Refresh
Refresh every n minutes
Refresh Data File on Open.
It is probably the last option you wish to enable.
Hope this has been of help.
Mike Rees
Mercia Group Ltd