The Jet Excel add-in
The Jet Excel add-in allows users to query a database using Excel-like functions to return real-time results into Excel. It consists of a Jet ribbon that is installed, enabled and configured within Excel. This ribbon contains all the tools needed to create reports via wizards such as the Report Wizard and Jet Function Wizard or create Pivot Tables from a Jet cubes data source.
The Jet Excel add-in is the product used to create reports.
Jet Enterprise is a suite of products, made up of the Jet Data Manager, Jet Dashboard Builder, and the Jet Excel add-in.
The Jet Data Manager is a back-end solution that allows companies to create and maintain data warehouses and OLAP cubes. It contains six predefined cubes built specifically for storing data for reporting. Typically this component is only installed on one machine and only accessible by a select few within the company with database management or IT experience.
Certain types of users, called Designers, can use the Jet Dashboard Builder to create dashboards for online or mobile consumption by anyone in the company with permission to do so.
To pull data, build reports and build Pivot Tables, users will use the Jet Excel add-in within Excel, as detailed above. The Jet Excel add-in allows users to create and run reports from the database, the data warehouse or cubes. This component is the one that is typically installed and used by the majority of users within the company.