4 ms·
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
by OrvalWintermute 4y 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.
- towawy 4y agoI'm curious, how did you establish the Postgres connection?
- OrvalWintermute 4y agoI 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/
- liotier 4y 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.
- codesnik 4y agoTook them long enough to add it.