Connecting to IMSMA Staging area from Excel

The PostgreSQL ODBC driver must be installed and an ODBC source created before loading the data into Excel.

Data tab - Data Source

1. On the Data tab, click on From Other Sources and choose From Data Connection Wizard.
   
   
   

   Wizard pane 1

2. Choose ODBC DSN and click Next.
   
   
   

   Wizard pane 2

3. Select your ODBC source and click Next.
   
   
   

   Wizard pane 3

4. First are the views listed and then the tables. Scroll until you find the table/view you would like to load into Excel. Select it and click Next.
   
   
   

   Wizard pane 4

5. Enter description and click Finish.
   
   
   

   Wizard pane 5

6. Select what type and where you would like the data and click OK.
   
   
7. The data is loaded into Excel.
   

   Data tab - Refresh

8. When the IMSMA Staging area is updated, the data in the Excel will be loaded again when you click on Refresh.