Making It Happen
Accounting and Information Technology, Assistance and Support
Sage 50 - Extracting information into MS Excel using ODBC

Extracting information from Sage in Excel is relatively simple and gives you superb flexibility and a great deal of scope for additional analysis.

These links are dynamic, that means that once set up you can refresh them to the latest information, you can write macros or VBA to refresh them.

Simple extraction of Nominal Ledger Balances

Creating a who's had what report using a  pivot table