• Call us at (602) 334-4670 | IT Help Desk (480) 582-5992  IT Help Desk

  • Office Connector

  • Sage 300 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 pre-built 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.
  • Since 2002, Office Connector Query has set the standard for Excel-based reporting with Sage 300 Construction and Real Estate.  Use it to generate reports with your business data by transforming Excel into a powerful reporting engine.  Using the Office Connector add-in, Excel becomes the environment in which you design reports and run reports.

  • Sage 300 Construction and Real Estate allows selected types of records and selected fields to be updated externally.  Office Connector Write puts this technology in your hands so that you can use Microsoft Excel to help you manage your Sage 300 Construction and Real Estate data. Whether you build your own solution, use one of our existing solutions, or have a solution built for you, you are in control of what is written.  Before any data is written, you can preview the information and then after data is written, you have a complete audit trail!

  • Sage 300 Construction and Real Estate allows selected types of records and transactions to be imported from properly formatted text files.  Office Connector Import puts this technology in your hands by removing the complexities associated with formatting your data according to the precise rules in Sage 300 Construction and Real Estate