Connection to PostgreSQL from Excel

From: "Paul Suworow" <paul(dot)suworow(at)gmail(dot)com>
To: <pgsql-odbc(at)postgresql(dot)org>
Subject: Connection to PostgreSQL from Excel
Date: 2018-08-27 20:19:30
Message-ID: 001f01d43e43$438e30b0$caaa9210$@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-odbc

Hi team,

Thank you for your great work! I am developing an Excel tool that should allow users to update tables and charts from a PostgreSQL database. My workbook currently connects to the database using the following VBA code:

Set objConnection = CreateObject("ADODB.Connection")
ConnString = "DRIVER={PostgreSQL Unicode};DATABASE=FMS;SERVER=[x];PORT=5432;Uid=[x];Pwd=[x]"
objConnection.Open ConnString

All works fine but the code requires PostgreSQL driver to be installed on user's machine.
Is there an alternative way to connect to a PostgreSQL database without pre-creating DNS or installing any drivers in advance?

Thank you for your help!

Kind regards,
Paul

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Rob Sargent 2018-08-27 20:30:34 Re: Erroneous behavior of primary key
Previous Message Daniel J Peacock 2018-08-27 19:50:51 Erroneous behavior of primary key

Browse pgsql-odbc by date

  From Date Subject
Next Message Kumar, Virendra 2018-09-04 13:38:43 psqlODBC
Previous Message Łukasz Jarych 2018-08-27 08:49:05 Re: Connection to PostgreSQL from Excel