Connecting to Microsoft Excel

Once Excel is open you need to connect to the IRIS SQL database:

1. Create a data source connection

2. Build the connection to your SQL Server and IRIS database

3. Lastly you need to choose the database view you wish to report on

The following demonstration shows how to connect Excel 2007 to your IRIS database:

If the video below does not display you will need Adobe Flash Player. Download the latest version here.