Cannot connect Excel to Postgres database?

Question

I would like to connect excel to a Postgres database. I have downloaded the ngpsql 4.0.17 from the below reference page https://github.com/npgsql/Npgsql/releases When I try to connect, I get this message:

the ngpsql version that comes with an MSI installer is https://github.com/npgsql/npgsql/releases/tag/v4.0.17

Note : I tried with all the versions that comes with an MSI installer in the releases page of npgsql

I still get the message above

Answer 1

Hi @Shruti Gupta

Since you have I tried with all the versions that comes with an MSI installer in the releases page of npgsql, I suggest you change the way, try using postgreSQL ODBC driver to connect to Postgres database.

The references I find:

Connect to a PostgreSQL database through ODBC on Excel 2016

PostgreSQL database: This connector requires one or more additional components to be installed before it can be used

Hope the information could he helpful.

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

---