Changes

{{Note | The [[Installation ODBC driver | PostgreSQL ODBC driver]] must be installed and an [[Create ODBC source | ODBC source]] createdbefore loading the data into Excel.}}

[[Image:Excel data source1.png|700px500px|center]]

'' Data tab- Data Source''

<li>On the '''Data''' tab, click on '''From Other Sources''' and choose '''From Data Connection Wizard''. <br/><br/>[[Image:Excel data source2.png|500px|center]]<div align="center">'' Wizard pane 1''</div> <li>Choose ''ODBC DSN'' and click Next. <br/><br/>[[Image:Excel data source3.png|500px|center]]<div align="center">'' Wizard pane 2''</div><li>Select your ODBC source and click Next. <br/> <br/>[[Image:Excel data source4.png|500px|center]]<div align="center">'' Wizard pane 3''</div><li>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. <br/><br/>[[Image:Excel data source5.png|500px|center]]<div align="center">'' Wizard pane 4''</div><li>Enter description and click Finish. <br/><br/>[[Image:Excel data source6.png|300px|center]]<div align="center">'' Wizard pane 5''</div><li>Select what type and where you would like the data and click OK.<br/><br/><li>flsjslThe data is loaded into Excel.[[Image:Excel refresh.png|500px|center]]<div align="center">'' Data tab - Refresh''</div><li>When the IMSMA Staging area is updated, the data in the Excel will be loaded again when you click on Refresh.

[[Category:VIENAA]]