Blogger
Share this content
0
3
9177

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

Replies

Please login or register to join the discussion.

thanks Mike
Thanks for your posting Mike. I had discovered those refresh otions but the boss (as usual) wanted more - in this case, more immediate or (as he put it) dynamic!

Thanks (0)

Refresh every 60 seconds
Richard

Refresh every 60 seconds is about as dynamic as it can get!

Mike.

Thanks (0)

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

Thanks (0)