JoeCode

Excel ODBC PostgreSQL notes

1. Determine what version of Excel you have installed (32 vs. 64 bit)
2. Download the latest ODBC driver from: https://www.postgresql.org/ftp/odbc/versions/msi/
3. Create a data source (DSN) in Excel
4. Configure connection

Create DSN

• Control Panel
• Administration
• Open ODBC Administrator
• User DSN
• Add new User DSN (MyPostgreDSN)
• check connection

Configure connection

• Select Data > Get Data > From Other Sources > From ODBC.
• In the From ODBC dialog box, if displayed, select your Data Source Name (DSN).
• Enter your connection string, and then select OK.
• In the next dialog box, select from Default or Custom, Windows, or Database connection options, enter your credentials, and then select Connect.
• In the Navigator pane, select the tables or queries that you want to connect to, then select Load or Edit.

Resources

• Microsoft Learn - ODBC
• Microsoft Support - import from data sources
• stack overflow - connect to a postgresql db in Excel