Software Review: Sage EIR (Excel Integrated Reporting). By David Carter
Sage released their Excel Integrated Reporting (EIR) module in version 11 of Line 50 (2005). We haven’t reviewed it yet on AccountingWEB, but it is proving very useful to some users, as reader Jeremy Hall recently pointed out in answer to his own Any Answers question.
Use SAGE EIR add-in in Excel
To answer my own question, thanks to helpful people at Sage, you need to activate the SAGE EIR add- in in Excel. This then allows you to log in to Sage through Excel.
Continued...
The full article is available to registered AccountingWEB members only. To read the rest of this article you’ll need to login or register.
Registration is FREE and allows you to view all content, ask questions, comment and much more.
Or if you are already registered, login here

you get functions as well
In addition to being able to run reports you get a set of new functions which you can include in your own spreadsheets to get data directly from the Sage database.
Just insert a function and there will be a new Sage Accounts category available