ActiveData for Office/SQL
ActiveData
for Office/SQL from InformationActive expands the capacity of MS Office
products and MS SQL database. It easily integrates with Word, Excel, Access,
Internet Explorer, and other applications.
In
Excel it leverages its capacity beyond one million row limit and adds many
advanced functions. These functions allow you to merge the sheets and compare
them. You can run a query, select the desired rows and sort them to suit your
needs. Also perform review functions, create sub-total and summary. You can split
and stratify the sheets, sample cells for analysis. It easily detects duplicate
entries and finds gap in sequence as in case of check bill numbers. It can run
Benfords law to perform analysis, top to bottom and vice versa. You can also
perform random monetary sampling.
The
SQL tool of the application gives direct access to database servers;
obviously MS SQL Server and others like Oracle, DB2, mySQL, Ace (XLSX and
ACCDB) and Jet (XLS and MDB). It uses MS OLEDB technology to access the
database. Supports automation for COM port and can run scripts with both VBA
and VBS scripts. Supports Remote Desktop, Citrix and Terminal Server. Runs on all
latest version of Windows OS including 7 & 8.