Zynk Workflow Documentation

Please Note: For the most up to date information on using the ODBC driver for linking Sage 50 Accounts and Microsoft Excel, please refer to Ask Sage Article 11564.  This information is a sample from the Sage 50 help documentation and is provided for reference.

  1. Start Microsoft Excel from Windows.

  2. Open the Data menu from the Microsoft Excel menu bar and choose the Get External Data option.

  1. Choose Create New Query.

The Choose Data Source window appears.

  1. Select the Sage 50 Accounts data source and click OK.

Note: If the accounts data source is not shown in this list box, click New Data Source and then click OK.

  1. If you have activated Access Rights in Sage 50 Accounts, then the User ID and Password you enter here should be the same as the logon name and password you have entered there.

If your password is for the whole company - that is, your Sage 50 Accounts Access Rights are turned off, then enter MANAGER in the User ID box and your password in the Password box.

  1. Click OK.

If you click OK without entering anything, the driver tries to use Manager as the User ID without a password. If Manager does have a password, an Incorrect User ID or Password window appears.

The Add Tables window appears.

  1. From the Add Tables window, select the table you require and click Add.

  2. Click Close when you have made your selection.

The Tables you have selected appear in list boxes.

Using your mouse, drag the right edge of this box to expand it, revealing the fields.

  1. Select the fields you require from the list by double-clicking on each field in turn until you have all the fields required. The fields, as you select them, appear in the database.

  2. Open the File menu from the menu bar and choose the Return Data to Microsoft Excel option.

The Get External Data window appears.

  1. Click OK to accept the options selected and to continue.

The fields you have selected appear in the Excel spreadsheet.

  1. You can now use the spreadsheet containing the Sage 50 Accounts data.

Back | Edit on Github