Simple Excel Link

Sage 50 - Linking Nominal Balances to an Excel spreadsheet

In Excel at the page where you wish to link.  Go to data select get external data and new database query. 

Select your Sage ODBC Datasource

Enter a valid user id and password (if you are not using access rights the user name is MANAGER and the password is your password for getting in to Sage.

In the available tables and columns box located and double click on the entry called NOMINAL_LEDGER.

Select the fields you want to retrieve by double clicking (I suggest ACCOUNT_REF, NAME and BALANCE)

Chose Next, You now have the opportunity to filter your selection

Choose Next, You now have the opportunity to sort your selection

Press the Finish button to return your data to Excel.

Choose the Cell you want as the top left hand area of your table and click OK

MsQuery will now run and get the data and put it into your spreadsheet.

You can update the query at any time by right clicking in the data area and choosing the refresh option. NB. Query can take a while to run.

You can also set up your query to run every time the workbook is opened so that it automatically refreshes itself.

Any problems please use feedback and quote the page reference "nominallink"