Providing Better Customer Service Since May of 2000

Over 200 Years of Combined Business Experience

Tel: 614-361-5393






Sage 300 CRE Timberline Office Connector

Sage 300 Construction and Real Estate (formerly Sage Timberline Office) Office Connector is a series of applications that automatically connects your Sage 300 Construction and Real Estate data to Excel. This solution can save you hours of time on reporting and analysis tasks using Excel. Best of all, Office Connector is easy to learn and use and comes with a number of prebuilt queries, getting you up and running immediately.

The Office Connector series consists of three separate products that allow you to query, report, and move data back and forth between Microsoft Excel and Sage 300:

  • Sage 300 Office Connector Query—Automatically retrieves data from Sage 300 for analysis and data manipulation using familiar Excel reports, worksheets, graphs, and more.
  • Sage 300 Office Connector Write—Maps data from your Excel worksheets and forms to corresponding writable fields within Sage 300.
  • Sage 300 Office Connector Import—Quickly saves Excel worksheets in formats that can be imported into Sage 300.
  • Sage 300 Office Connector Financials—Use your Sage 300 financial data in Excel to create robust financial reports leveraging all of Excel’s features, including: formatting for high-quality presentation, graphing and charting, pivot tables, and more.

These innovative solutions will transform the way you work with your Sage 300 Construction and Real Estate data, expanding your analysis and reporting options through a familiar set of tools.

View your Sage 300 Construction and Real Estate data the way you want to see it—through a live connection to Microsoft Excel. Take advantage of Excel’s graphic, formatting, and flexible placement of workbook functions to visualize your information like never before.
•Seamlessly access your Sage 300 data from Excel.
•Embed dynamic queries that retrieve data from your Sage 300 database and place it into your Excel workbooks.
•Refresh data at any time with the click of a button.

Sage 300 Construction and Real Estate
• Transfer Sage 300 Construction and Real Estate data to/from Excel with ease.
• Take advantage of Excel’s flexibility and familiarity.
• Reduce the time your company spends on data entry.
• Improve workflow and reporting.
• Empower employees to use Excel as a reporting and productivity tool.
• Gain added confidence in your numbers and data.

Office Connector Write

Send your Excel data directly to Sage 300 Construction and Real Estate. Wizards make it easy to determine which fields can be created or modified. The Approve Changes window puts you in complete control of what is written.
•Instruct Sage 300 Office Connector to map values from your Excel worksheets to the proper fields and records in your Sage 300 database.
•Preview information to be written before anything happens to ensure data security and

Office Connector Import

Get the capability you need to automatically create Excel files that are compatible with various import functions in your Sage 300 Construction and Real Estate database. Create import files from spreadsheets with the click of a button—without the need to
recreate or reformat the information.
•Import Excel files into Sage 300 without modifying or adapting the layout of your worksheets.
•Create a seamless import process with the click of a button.Prevent lost time you’d normally spend recreating properly formatted import files.

For More Information Contact:
Information Technology Outlook, Inc.
2783 Martin Rd Dublin, OH 43017
Copyright © 2016 Information Technology Outlook, Inc.
Last modified: 10/16/16