Psqlodbc | X64 [best]

psqlODBC is the official ODBC driver for PostgreSQL. The is for 64-bit Windows applications (e.g., Excel 64-bit, Power BI, SSIS, custom 64-bit apps). It allows 64-bit clients to connect to PostgreSQL databases via ODBC.

The PSQL ODBC driver is a driver that enables ODBC-compliant applications to access PostgreSQL databases. It allows users to connect to a PostgreSQL database from applications that support ODBC, such as Microsoft Excel, Access, or Visual Basic. psqlodbc x64

Open the via Windows Administrative Tools. psqlODBC is the official ODBC driver for PostgreSQL

DRIVER=PostgreSQL ODBC Driver;SERVER=localhost;PORT=5432;DATABASE=mydatabase;UID=myuser;PWD=mypassword; such as Microsoft Excel

: Click the System DSN tab (which makes the connection available to all users on the machine) and click Add .