|
The CONNX ExcelLink
tool
enables any user of Microsoft® Excel to add to and update
data in CONNX data sources through Excel spreadsheets.
It’s fast, it’s easy, and it’s secure. ExcelLink takes
advantage of all of the benefits of CONNX security features,
which are totally configurable, incorporate individual user
IDs and passwords, and are compatible with all CONNX data
sources.
ExcelLink
is a powerful
tool that facilitates fast data repairs and data cleansing
within the easy-to-use, familiar Excel application. Data can
be manipulated, cleansed, and modified manually, using Excel
formulas and other Excel features. After completing the data
manipulation, the CONNX ExcelLink tool takes over and performs
the requested updates in the data source table.
ExcelLink
turns Excel into a
user-friendly “disconnected recordset” that can help you save
time and money by enabling your users to handle data with
ease
in a familiar setting. It eliminates re-keying of data, and
was designed with both business and IT users in mind. In
addition to simplified update capability, ExcelLink also has
the ability to validate data and provide statistics regarding
the Excel data and the data source table(s).
There are many other benefits to using ExcelLink besides
freeing staff to perform other "value-added" tasks:
No program development and maintenance
Extension of existing ERP and package functionality
Minimum training
Reduced errors
Savings benefits include:
Automation of regular update/load tasks
Rapid solution for ad-hoc requests
Extension of existing package functionality with development
Minimum training required, so quick ROI
Eliminate re-keying of data, saves time
|
