Connecting to your Sage 50 Company using OLEDB

Related topics

Learn more about OLEDB

See a list of the tables of data

Certain programs, such as Microsoft Excel, allow you to connect to external databases, such as your Sage 50 company database. Using the OLEDB connector, you can connect Excel directly to your Sage 50 company and create reports in that way. To do this, follow these steps (example for Microsoft Excel 2007 and higher):

  1. Open Microsoft Excel and select a new spreadsheet.
  2. On the Data tab, click Existing Connections in the Get External Data group.
  3. Click Browse for More..., and navigate to your company's data folder on the hard drive (example Peachtree/Company/BCS).
  4. Select CrystalReports.udl and click Open.
  5. On the Data Link Properties dialog, enter the user name (ID) and password for your company. This is set up on the Data Access/Crystal Reports tab in Maintain Users in Sage 50 in the Access from Outside Sage 50 section. The user name (ID) is always Peachtree and may already be entered for you. Click OK. when finished.
  6. Select the table you want and click OK.
  7. On the Import Data dialog, click Properties.
  8. On the Connection Properties dialog, select the Definition tab.
  9. In the Connection string text box, make sure the ID and password match those entered in step 5. The ID should be Peachtree. You'll need to enter the password between the "=" and ";" characters after "Password".
  10. Click OK..

    11. Note: If you get a warning message about the workbook not matching the information in CrystalReports.udl, you can safely ignore this warning and proceed with the changes.

  11. Click OK. on the Import Data dialog.
  1. Open Microsoft Excel and select a new spreadsheet.
  2. Select Data, Import External Data, Import Data.
  3. Navigate to your company's data folder on the hard drive (example Peachtree/Company/BCS).
  4. Select CrystalReports.udl and click Open.
  5. On the Data Link Properties dialog, enter the user name (ID) and password for your company. This is set up on the Data Access/Crystal Reports tab in Maintain Users in Sage 50 in the Access from Outside Sage 50 section. The user name (ID) is always Peachtree and may already be entered for you. Click OK.when finished.
  6. Select the table you want and click OK.
  7. On the Import Data screen, click the Edit Query button.
  8. In the Connection text box, make sure the ID and password match those entered in step 5. The ID should be Peachtree. You'll need to enter the password between the "=" and ";" characters after "Password".

  9. Click OK..

  10. Click OK. on the Import Data dialog.