Solved Excel Query just goes from strength to strength

jimbo45 · May 2, 2022

I just wish the other parts of Ms development were even half as good as those on EXCEL
The latest query system now with ability to pull in data from even large commercial data base systems just gets astoundingly easier and better.

SAP is very widely used in Enterprises for ERP and other applications -- and its main database system these days is HANA. Previously to pull data from HANA you'd need to employ expensive coders writing "ABAP" -- a sort of "Cobolish" language with a bit of OO and SQL in it and it could take a while to get your data.

Now you can run an excel query against it -- brilliant as SAP HANA is now a recognised data source for EXCEL. The ODBC from SAP is downloadable and works in exactly the same way that I've previously showed for MariaDB, and I'm sure others using Ms's own SQL server also have tried the query facility.

I can't see any office suite clone coming up anywhere near to EXCEL for any of these facilities -- and gathering / analysing data is increasingly more important in even for quite "Low level" (or "junior" jobs these days.

Here's Query into a Maria DB test data base returned to an EXCEL spread sheet as previously shown.

So or once Ms --well done. Very satisfied customer here.

Cheers
jimbo

RFS · May 2, 2022

You've exposed a lot of people's email addresses in that attachment ...

Bree · May 2, 2022

RFS said:
You've exposed a lot of people's email addresses in that attachment ...

No, he did say that it's a 'test database'. They are all fake addresses, there is no such domain as classicmodelcars.com.....

johnlgalt · May 2, 2022

It would be interesting to see how Rows stacks up against Excel - or Excel stacks up against Rows, as the case may be.

The spreadsheet with superpowers

Combine the power of a spreadsheet with built-in integrations from your business apps. Automate workflows and build tools that make work simpler.

rows.com

It's very, very powerful as well.

One of the places that Rows shines is in a similar manner as you've been describing in Excel:

<span>Level up</span> your spreadsheet game

Connect and analyze data, build forms and dashboards, automate and share them. Eliminate manual work that slows you down.

rows.com

jimbo45 · May 2, 2022

RFS said:
You've exposed a lot of people's email addresses in that attachment ...

Hi there
Totally Test data base with fictional generated stuff. !!!!!! We have strong data protection laws (at least where I live).
If people want to register a domain with that name later then that's up to them. However restricting the test system to local lan (192.168.xxx.xxx) it's not going to "conflict" with any Internet domains.

I remember a serious court case a while back when a well known brand of soap powder (in the days before washing machine tablets) was advertising itself as markedly superior to "Brand X". Someone made and registered a "Brand X" and won an almost obscene amount of money in Court with the Court ruling the original product was "falsely advertising" its product over "Brand X" and serious damages were awarded to "Brand X".

@johnlgalt

Creating dashboards etc is a great idea for some situations - however this is really just for very quick queries rather than designing project cockpits etc. Also for most of "The good stuff" it's not free etc and spread sheet size is limited for the "free" version. Excel with pivot tables etc has zillions of "What if" scenarios in it too and SAP has built in Bex (Business explorer analyser) .

Cheers
jimbo