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. You have the freedom to organize your data in Excel how you wish and Office Connector Import collects your data and assembles it into the desired import files. There is no need to modify or adapt the layout of your report to accommodate the file formats required by Sage 300 Construction and Real Estate. Once the Office Connector Import functions have been added to a report, you can use that report over and over again to quickly create import files. You will not lose time recreating and/or reformatting the information to produce import files each time!
Owners of Office Connector Import use it for…
|Saving Import Files||When you are ready to create an import file, simply click a button and let Office Connector Import do the rest! There is no need to rearrange or reformat your worksheets or to save your workbook in a different format. Office Connector Import collects the data it requires based on the instructions within the workbook and then assembles your import file in the correct format.|
|Sample Solutions||A set of over 10 report designs is included for you to use or to serve as starting points and educational resources. Read more...|
|Macro Support||Creating an import file is only the first step in getting your data into Sage 300 Construction and Real Estate. Next, the file must be imported using one of the import functions in Sage 300 Construction and Real Estate. To make this a more streamlined process, you can record a macro in Sage 300 Construction and Real Estate that includes the steps needed to import your file. Then, just give Office Connector Import the name of your macro and let it run the macro for you when it creates the import file.|
|Online Help||All Office Connector functions and tools are fully documented in online help that is quickly accessible from within Excel.|
Office Connector Import is licensed separately for each type of import file that you plan to create. There is no restriction on the number of users who can utilize a license at one time. The types of import files that can be licensed include:
* Import function is provided by a separate program that is installed with Office Connector Import. Sage 300 Construction and Real Estate 9.5 or higher is required for this feature.
With an Office Connector Import Designer license, you can add import capability to your own Excel worksheets by following the steps in the easy-to-use wizard.
& Watch this two-minute video demonstrating Office Connector Import Designer
Click here for information about supported operating systems, versions of Excel, and versions of Sage 300 Construction and Real Estate.