AutoSoft Systems
        AutoSoft Systems 2 Round Hill Court
        East Greenwich, RI 02818
        401.884.5653 Fax
                        401.996.3631 Cell
AMDG       Decision Ready Information! autosoft@aol.com
Commercial & custom multi-user computer software for a variety of applications including performance metrics, statistical analysis, data extraction and merger from multiple large databases, computer simulation and management information systems.  Founded in 1982.
We know Excel! Whenever possible, Excel is the user interface, VBA is the programming language, ODBC connects to the database of your choice.
Home About Us Literature Wire & Cable Pharmaceutical & Biotech Construction Management Commercial Products Custom Solutions
Contact Us Events Downloads
Sage 300 Data Extraction and Reporting
Sage 300 is the leading Construction and Real Estate property management software.  AutoSoft Systems has developed data extraction tools to allow Sage users to extract all the data from the 300+ tables in the Sage database for further manipulation and use.
This tool provides the foundation for an infinite variety of reports and exports.  In this fashion, the user can extract information out of the Sage 300 database and automatically manipulate it for automatic insertion into another application, eliminating double data entry.
This easy to use tool extracts the entire contents of every table in the Sage 300 database, and places the data in a series of Excel workbooks.  Here is a screen shot of the ensuing directory:
This redacted screen shot displays the partial contents of the APM_MASTER_DIST_PAYMENT table