InformationActive.com

2.0.46 Update Released on July 8, 2010 - More Information

ActiveData for Office / SQL is a Windows application that leverages the power of Microsoft Office and SQL databases to extend your reach beyond the 1 million row barrier of Excel and offer enhanced data analytics functionality with tight integration to Access, Word, Excel, Internet Explorer and many other popular business applications.

Click here to see what's new in version 2.

ActiveData for Office / SQL provides you with functionality found in much more expensive software solutions like ACL and IDEA and is up to 3 times faster at 0% of the cost. Those of you familiar with ACL and IDEA will be able to master the program in short order. New users will find it easier because of its streamlined user interface and significantly shortened learning curve.

Make sure that you choose the SAVE option. Once the download completes, click the Run button to install. Please note you need to have administrative privileges to install the software. Admin privileges are not required to run it. To get started, choose Help -> Open Getting Started guide.

ActiveData for Office / SQL runs on Windows XP, Vista, Vista x64, Windows 7 and Windows 7 x64.

By using the power of Microsoft's latest data access technologies, ActiveData For Office / SQL is able to process millions of rows of data and provide easy to use results that are integrated into your Microsoft Office applications. You can further manipulate and analyze your results using ActiveData For Excel.

Powerful data analysis features let you merge and compare sheets; query and select rows; sort, summarize and sub-total; split, sample and stratify; analyze duplicates (de-dupe) and detect gaps in sequenced items such as check and invoice numbers; perform top/bottom item analysis; apply Benfords law to perform digital analysis; Random and Monetary Unit (PPS - Probability Proportional to Size) sampling.

ActiveData for Office / SQL supports direct access to Oracle, DB2, MS SQL Server, mySQL, Jet (MDB and XLS) and Ace (ACCDB and XLSX) databases using Microsoft's OLEDB data access technolgies. It also sports full support for COM automation and can be scripted with both VBScript and VBA

What's New In Version 2

• New price: FREE (was $449)
• Office 2010 style Ribbon user interface and support for Windows 7
• Now works natively with MS SQL Server, Oracle, DB2, MySQL, ACE (ACCDB / XLSX) and JET (MDB / XLS)

How To Update Your Existing Copy

Version 2.0 is now free. To update your copy of ActiveData For Office / SQL, uninstall your current version and then download and install the latest version. Software reactivation is NOT required.

ActiveData For Office / SQL was initially designed to overcome Excel's 65,536 row limitation but since Excel 2007 handles just over a million rows and most of the data that our users can throw at it, we have decided to offer it as a free download. With a zero cost product on the market, we hope to make it easier for more professionals to implement data analytics software within their organizations. The techniques you learn with our software can easily be applied to other popular data analysis packages. We are keen to see the software used in educational environments and hope that these and other users will share some of the course materials that they develop with the ActiveData community via our online forums.