Upload Excel & Access Data Files into SAP with ERP Squared (ERP

By: Quadrate  11-11-2011
Keywords: SAP, Data Management, It Resource

Much of the data being uploaded into SAP already exists in a digital format such as Microsoft Excel spreadsheets or Microsoft Access databases. Moving data out of these spreadsheets and databases requires either manual data entry or ABAP development resources.

Quadrate has an easier solution. For a fraction of the cost of a regular inflexible custom-built ABAP upload program, ERP² can be used to upload Excel files and Accessfiles directly into SAP without any ABAP programming or technical expertise.  Utilizing the Microsoft Office suite as the data management platform, users can manipulate and prepare data for upload without any additional training or software.

ERP², pronounced ERP Squared, is a desktop application that is installed directly onto the users' workstation without any need for changes/installations to the SAP systems.  The installation process is quick and simple, and the user-friendly interface can be mastered in a couple of hours. Most customers are creating their own templates and uploading data the very same day that ERP² is installed.

ERP² can be used for a  within the different SAP modules.  Common uses are Mass Uploads of SAP data, Mass Maintenance of SAP data, SAP data migration and the automation of SAP data entry.

The procedure to upload Excel or Access files into SAP is a simple three step process designed for even the most inexperienced of end-users.  The user records the transaction by executing it from within ERP².  Once the recording is complete an Excel or Access file is automatically created for the user to add the data to upload. The final and simplest step in the process is to return to ERP² and select the file to upload the data.

  • Simple to install and use

  • Preserves all existing SAP security

  • Works on a wide range of standard and custom transactions

  • Reduces costly IT resource requirements
  • Provides mass upload and maintenance functionality without any programming

  • Utilizes familiar data management tools thus eliminating additional training

  • Reduces time to change and upload data in SAP by eliminating manual data entry and time necessary to create custom upload programs

Keywords: Data Management, Data Management Tools, It Resource, SAP,

Contact Quadrate

Email - none provided

Print this page


Other products and services from Quadrate


SAP Data Upload & Extraction Solutions

Business users do not need to understand SAP tables or fields, they can create the query by stepping through a transaction in SAP's familiar GUI - this will record the fields the user has selected and will automatically create the complete query. ERP² enables accurate and rapid transfer of data from spreadsheets or databases into SAP in a simple three-step process.


Extraction & Reporting into Excel or Access

The extensive report writing functionality allows users to create complex business reports in minutes, and reports may be exported in several formats including Excel, TIFF, PDF and HTML. Quadrate's R/3 extraction solution for SAP data provides a simple and easy to use method for performing ad-hoc queries against an SAP system without any programming expertise.


Transfer data between Excel and SAP with Quadrate software - news

Cincinnati, OH, May 1, 2006 - Quadrate announces the launch of its US Operations on May 1, 2006. Our offices are located at 4555 Lake Forest Drive, Suite 650, Cincinnati, OH 45242. The United States is currently the largest SAP market and to..


Transfer data between Excel and SAP with Quadrate software - version of erp C B C AE released

The file explorer would attempt to load the Desktop folder first before loading the load file folder causing potential performance issues. After updating the name of a field in the template editor a newly created load file would not reflect the changes made. Conditional scripts in upload mappings applied to the first line item of a loop would cause the upload to fail.


Transfer data between Excel and SAP with Quadrate software - version of erp C B released

Fix for SAP systems that do not supply a Continue Without End logon option for multiple logons. Allow the backup of data from SAP transactions to allow rollback on certain transactions. Additional security checks for upload mappings with shared templates. Added the ability to change the system a upload is scheduled on. This version contains the following new features and bug fixes. 2010 - Quadrate releases version 9.9.302 of Data Workbench.


Most Common Uses of ERP² Identified by our Customers

Master Data creation, changes or deletions of vendor, customer, material and equipment master as well as fixed asset or functional location data. ERP² may be used to upload both Master and Transactional Data into SAP. Mass updates and changes for employees, prices, projects etc. Sales orders and vendor invoices with multiple line items. Creation of master data for testing business scenarios.