Hacker News new | ask | show | jobs
by OrvalWintermute 1272 days ago
110% agreement on Excel

The ability create a relational database in Excel with vlookups and hlookups, then capture it all into a macro is amazing.

I've really enjoyed using Excel as a Postgres frontend, with a real Postgres DB instance handling data, and then using the report functionality to dump to Word.

While a pro reporting engine and cutting out MS Office altogether would be a better longterm solution, it is hard to beat for quick & dirty results.
2 comments
liotier 1272 days ago
> The ability create a relational database in Excel with vlookups and hlookups,

Do yourself a favour and ditch vlookup and hlookup in favour of the recently introduced xlookup, which even obsoletes index/match !

I try to keep my exploratory joins out of Excel, but I admit that I often don't resist the immediacy of Excel's poor man's joins located right where I need them.

link
codesnik 1271 days ago
Took them long enough to add it.
link
towawy 1272 days ago
I'm curious, how did you establish the Postgres connection?
link
OrvalWintermute 1272 days 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-datab...

[2] https://www.postgresql.org/download/products/2-drivers-and-i...

[3] https://www.devart.com/excel-addins/postgresql/

[4] https://jdbc.postgresql.org/

link