In the continued
effort to provide you with Year 2000 remediation tools, Microsoft
offers a list of companies that offer Year 2000 remediation tools
and may be able to assist you in your Year 2000 remediation efforts.
For this tool to be listed on this site does not indicate an
endorsement or recommendation on the part of Microsoft for either
the manufacturer, its products or the underlying technologies being
used. You will need to do your own assessment to determine if the
tools offered meet your needs. For information regarding this
company or its Year 2000 solutions, please contact the company
directly.
http://www.graycorp.com.au/remediator/intro.htm
Remediator- First Fully Automated Remediation Tool
for both Microsoft Access & Excel
The Remediator is the first tool, which will actually FIX
Non-Compliant dates within both Microsoft Access and Microsoft Excel
Data Files û eliminating the need for you to purchase individual
tools for each application.
A Wizard will guide you through the basic scanning and
remediation procedures and there is an extensive on-line Help
facility available.
Individual files or large groups of up to several thousand files
can be scanned for both Compliant and Non-Compliant Dates.
The Remediator can search for all 72 known date formats,
including Full, Partial and Ordinal. International Date types can be
added and 33 date separators are recognized.
Once scanning has been completed an on-screen report identifies
each date field within each file as being either Compliant or
Non-Compliant. These reports can be printed or exported to a word
processor or spreadsheet for further analysis.
Once the dates have been identified, the Remediator then provides
you with the ability to automatically convert all Non-Compliant
dates to the Compliant 4-digit format. To ensure complete security
of data, the original data file is preserved and a copied made which
is then remediated.
The Remediator's ease of use and powerful functionality makes it
the ideal tool for any organization whether they are a small
business, large corporation or Government Department.
It will enable you to automatically SCAN and FIX dates in files
such as:
- Excel *.xls
- Access *.mdb
- Paradox *.db
- FoxPro *.dbf
- Dbase *.dbf
- Lotus *.wk1, *.wk2, *.wk3, *.wk4,
*.123
- Text *.txt
- Comma Separated *.csv
It is able to completely and accurately SCAN and FIX: Calculated
Dates, Hidden Sheets, Protected Worksheets, Hidden Cells, Macros
& Protected Projects within Excel, and it clearly Identifies and
Analyzes Visual Basic application code and / or references to
function and Macro procedures.
It has a number of Scanning Parameters, which can be altered to
suit your specific requirements. These parameters include; File
Characteristics, Date Formats, Date Characteristics & Path to
File.
For simplicity, the most commonly required parameters have been
set as "Defaults" giving users with even the most basic knowledge of
computers the ability to scan & fix their data files.
It is a Windows program, which operates under Windows 95, 98 or
NT.
It can be used on a single stand alone PC or across a significant
Client Server Network of several hundred workstations including NT,
Novell and LANtastic.
The Remediator is extremely fast, being able to SCAN and FIX a 15
MB file containing 39,000 records within 8 - 10 minutes.