4 ms·
I used ODBC [1] out of the big list of options [2] which gets a bad rep but worked for my use-cases. The commercial devart plugin [3] looks pretty neat too but
by OrvalWintermute 4y ago
I used ODBC [1] out of the big list of options [2] which gets a bad rep but worked for my use-cases.
The commercial devart plugin [3] looks pretty neat too but I haven't used it yet
I've also tried the JDBC connectivity option too [4], but with some different use-cases in mind for Postgres (not about Excel)
[1] https://datacornering.com/how-to-connect-to-postgresql-database-with-excel-or-power-bi/ https://datacornering.com/how-to-connect-to-postgresql-datab...
[2] https://www.postgresql.org/download/products/2-drivers-and-interfaces/ https://www.postgresql.org/download/products/2-drivers-and-i...
[3] https://www.devart.com/excel-addins/postgresql/ https://www.devart.com/excel-addins/postgresql/
[4] https://jdbc.postgresql.org/ https://jdbc.postgresql.org/