|
|
|
|
Linking the nominal balances to an Excel 2000 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" |
|
