Extracting data from Sage50 by downloading the standard reports can be challenging and time-consuming. Often the format of the data extracted required tidying up before it is in a usable form.
Similarly, the standard Sage50 Excel Add-In can be restrictive in the data and format it allows you to bring into your spreadsheet.
We find that using the ODBC driver to link directly to the data is the simplest and most flexible approach.
It can be intimidating and complex but for most uses it is actually simple, straight forward and very useful.
We have produced a clear, simple guide to get you started. Using the techniques in our guide will make reporting in Excel much easier.
Why not download our free guide now?