NoPublic, bureaucrat, administrator
6,632
edits
Changes
no edit summary
{{Note | The Prerequisites: the [[Installation ODBC driver | PostgreSQL ODBC driver]] must be installed and an [[Create ODBC source | ODBC source]] created.}}
[[Image:Excel data source1.png|500px|center]]
</div>
<ol start="1">
<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 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>The data is loaded into Excel.
[[Image:Excel refresh.png|300px|center]]