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

Revision as of 07:07, 17 December 2014

	The PostgreSQL ODBC driver must be installed and an ODBC source created.

Data tab - Data Source

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

Wizard pane 1
Choose ODBC DSN and click Next.

Wizard pane 2
Select your ODBC source and click Next.

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

Wizard pane 4
Enter description and click Finish.

Wizard pane 5
Select what type and where you would like the data and click OK
The data is loaded into Excel.

Data tab - Refresh
Click on Refresh to read the data from the database.

@@ Line 3: / Line 3: @@
 [[Image:Excel data source1.png|500px|center]]
 <div align="center">
-'' Data tab''
+'' Data tab - Data Source''
 </div>
 <ol start="1">
@@ Line 22: / Line 22: @@
 </div>
 <li>First are the views listed and the tables. Scroll until you find the table/view you would like to load into Excel. Select it and click Next.
+[[Image:Excel data source5.png|500px|center]]
+<div align="center">
+'' Wizard pane 4''
+</div>
+<li>Enter description and click Finish.
+[[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
+<li>The data is loaded into Excel.
+[[Image:Excel refresh.png|300px|center]]
+<div align="center">
+'' Data tab - Refresh''
+</div>
+<li>Click on Refresh to read the data from the database.
 </ol>