MIMICExcel is an application that users can run from within Microsoft Excel. Users first open Excel and then from within Excel, MIMICExcel can be opened.
The main purpose for using MIMICExcel is to table the query results in an Excel spreadsheet, use Excel functionality with the query results, and to be able to automatically refresh or update the query results.
MIMIC is a stand-alone product and application that allows users to create queries, and to display the query results in a chart or table. MIMICExcel is a program that is used from within Excel. On the interface, differences in MIMICExcel include the title bar and the addition of the MIMICExcel toolbar above the menu bar.
The following shows the differences between the two applications:
| MIMIC | MIMICExcel |
|---|---|
Is a stand-alone application. | Is a program that runs within Microsoft Excel. |
| Can create a single query. | Can create multiple queries. |
Saves queries with a .llc file extension. | Saves or embeds queries in MIMICExcel, and saves each query separately with a .llc file extension for use in MIMIC. |
| Tables query results in the Table window. | Tables query results in an Excel spreadsheet. |
Cannot refresh or update query results from the server. | Can refresh or update query results from the server. |