Connecting to IMSMA Staging area from Excel

From IMSMA Wiki

Revision as of 06:57, 17 December 2014 by Alnaucler (talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

Jump to: navigation, search

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

Excel data source1.png

Data tab

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.

Business Intelligence

Staging Area Generator	Install Staging Area Generator · Using Staging Area Generator · Post Processing SQL Scripts · SAG Spatial reference system · Name Rules Staging Area · Scheduling the Staging Area creation

IMSMA Staging Area	IMSMA Staging Area Database · Connecting to IMSMA Staging area from ArcGIS · Connecting to IMSMA Staging area from Excel · Sharing an IMSMA Staging Area

Other Reporting Tools	Other Reporting Tools

Indicators	Introduction to indicators

Retrieved from "http://mwiki.gichd.org:8090/mediawiki/index.php?title=Connecting_to_IMSMA_Staging_area_from_Excel&oldid=18153"

VIE