The main Sage 50 Accounts application also allows users to download sales, purchase, customer, supplier and nominal transactions directly in to Microsoft Excel. As with the Sage upload facility you can create an ODBC (Open Data Base Connectivity) link that allows you to constantly gain access to the Sage tables that hold the raw data. A spreadsheet can then receive live data updates from Sage at the click of an Excel button! ODBC sits in the background on most pcs and it’s often just a case of firstly knowing it’s there and secondly knowing how to use it!
Again many businesses often generate system reports and manually enter the information into Excel. Sage 50 downloads can be performed very quickly and cut unnecessary data entry hours to a minimum. Once created the ODBC links are saved with the spreadsheet ready for you to use the next time the file is opened. Downloads can be tailored to pull specific data so as to keep file sizes small. With good Excel knowledge efficient company reports can be generated very quickly.
To find out more about Sage downloads please contact me.