How to connect postgresql database through ODBC driver in excel
Postgresql has ODBC driver " psqlodbc " which will be used to connect to postgresql databases. In this post, we are connecting to postgresql from excel using ODBC driver. Step1: Verifying the existing ODBC driver in windows (both 32 and 64 bit driver) for availability of postgresql driver. 32-bit driver , we noticed that there is no postgresql driver in the drivers list ( Name column values doesn't start with Postgres text). 64-bit driver , we noticed that there is no postgresql driver in the drivers list ( Name column values doesn't start with Postgres text). Step2: Checking the current postgresql server version, to get the corresponding psqlodbc driver. As per below screen shot, current version is " 10.10 ". i will try to get and install psqlodbc of 10.10 version. Step3: When check the psqlodbc driver ( https://www.postgresql.org/ftp/odbc/versions/msi/ ), i have found the, psqlodbc_10_3 is the last version that was a...