Excel postgres odbc driver

psqlODBC - PostgreSQL ODBC driver. psqlODBC is the official PostgreSQL ODBC Driver. It is released under the Library General Public Licence, or LGPL. Downloads are available in source and binary formats at the PostgreSQL downloads site. The PostgreSQL ODBC Driver is a powerful tool that allows you to connect with live PostgreSQL data, directly from any applications that support ODBC connectivity. Access PostgreSQL databases from virtually anywhere through a standard ODBC Driver interface. It's the single biggest issue we've had with setting people up on PostgreSQL within Excel/Access. Bottom line: if your Excel instance is bit (which is often the case), then you need to use the bit ODBC driver. The latest Pg ODBC driver has both bundled in the same assembly, so the trick is to go into bit ODBC and set up the driver that www.doorway.rus: 4.

I'm having trouble using ODBC to connect from Excel to a PostgreSQL database. I tried to follow this answer, without success, and this solution from MS, without any better results. It's the single biggest issue we've had with setting people up on PostgreSQL within Excel/Access. Bottom line: if your Excel instance is bit (which is often the case), then you need to use the bit ODBC driver. The latest Pg ODBC driver has both bundled in the same assembly, so the trick is to go into bit ODBC and set up the driver that. To configure the ODBC data source for the PostgreSQL database, open ODBC Data Source (64–bit) 🡪 Click on System DSN tab 🡪 Click on Add. A dialog box Create a new data source opens. Select PostgreSQL Unicode (x64) driver and click on Finish. Another dialog box PostgreSQL Unicode ODBC Driver (pSQLODBC) Setup opens.

For example, if you are only using a 32bit version of Microsoft Excel you will need to select the 32bit driver (the one that isn't marked with x64 in its name). Nov Create PostgreSQL ODBC Excel table · Downloaded the psqlodbc installation file from this link (64 bit). · Opened the control panel |. Obtain and Install an ODBC Driver. While the free PostgreSQL ODBC driver can successfully be used from Windows, you must currently.