Difference between revisions of "Connecting to IMSMA Staging area from Excel"

Latest revision as of 20:31, 20 February 2020

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

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.