Solved Excel Query just goes from strength to strength


jimbo45

Well-known member
Power User
VIP
Local time
5:12 AM
Posts
1,871
Location
Hafnarfjörður IS
OS
Windows XP,7,10,11 Linux Arch Linux
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.

Screenshot_20220425_064441.png


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

Cheers
jimbo
 
Last edited:

My Computer

System One

  • OS
    Windows XP,7,10,11 Linux Arch Linux
    Computer type
    PC/Desktop
    CPU
    2 X Intel i7

RFS

Well-known member
Member
VIP
Local time
6:12 AM
Posts
243
Location
Derbyshire, UK
OS
Windows 11 Home
You've exposed a lot of people's email addresses in that attachment ...
 

My Computers

System One System Two

  • OS
    Windows 11 Home
    Computer type
    PC/Desktop
    Manufacturer/Model
    Self-build
    CPU
    Intel I3-10100
    Motherboard
    MSI H410M-PRO
    Memory
    16 GB
    Graphics Card(s)
    Nvidia GT 1030
    Sound Card
    Motherboard default
    Monitor(s) Displays
    Philips 27 inch
    Screen Resolution
    1920x1080
    Hard Drives
    Samsung EVO 970 NVMe SSD 256 Gb
    Samsung QVO 870 SATA SSD 2 Tb
    PSU
    ATX 450W
    Keyboard
    Logitech
    Mouse
    Logitech Wireless
    Internet Speed
    930 Mb down / 120 Mb up
    Browser
    Edge
    Antivirus
    Windows Defender
    Other Info
    Microsoft Office 2021 Plus
  • Operating System
    Windows 11 Home
    Computer type
    PC/Desktop
    Manufacturer/Model
    Self-build
    CPU
    Intel i3-8100
    Motherboard
    Gigabyte Z370 D3
    Memory
    16 Gb
    Graphics card(s)
    Nvidia GT 720
    Sound Card
    Motherboard default
    Monitor(s) Displays
    Philips 27-inch
    Screen Resolution
    1920x1080
    Hard Drives
    Samsung 960 NVMe SSD 256 Gb
    Seagate 2 Tb HDD
    PSU
    ATX 450W
    Mouse
    Logitech Wireless
    Keyboard
    Microsoft
    Internet Speed
    930 Mb down / 120 Mb up
    Browser
    Edge
    Antivirus
    Windows Defender

Bree

Well-known member
Guru
VIP
Local time
6:12 AM
Posts
4,133
Location
S/E England, UK
OS
Windows 11 Home
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.....

1651494918808.png
 

My Computers

System One System Two

  • OS
    Windows 11 Home
    Computer type
    Laptop
    Manufacturer/Model
    Acer Aspire 3 A315-23
    CPU
    AMD Athlon Silver 3050U
    Memory
    8GB
    Graphics Card(s)
    Radeon Graphics
    Monitor(s) Displays
    laptop screen
    Screen Resolution
    1366x768 native resolution, up to 2560x1440 with Radeon Virtual Super Resolution
    Hard Drives
    1TB HDD
    Browser
    Edge, Firefox
    Antivirus
    Defender
    Other Info
    fully 'Windows 11 ready' laptop. Windows 10 C: partition migrated from my old unsupported 'main machine' then upgraded to 11. A test migration ran Insider builds for 2 months. When 11 was released on 5th October it was re-imaged back to 10 and was offered the upgrade in Windows Update on 20th October.


    My SYSTEM THREE is a Dell Latitude 5410, i7-10610U, 32GB RAM, 512GB ssd, Windows 11 Pro.
  • Operating System
    Windows 11 Pro
    Computer type
    Laptop
    Manufacturer/Model
    Dell Lattitude E4310
    CPU
    i5 M 520
    Motherboard
    0T6M8G
    Memory
    4GB
    Screen Resolution
    1366x768
    Hard Drives
    500GB HDD
    Browser
    Firefox, Edge
    Antivirus
    Defender
    Other Info
    unsupported machine: Legacy bios, MBR, TPM 1.2, upgraded from W10 to W11 using W10/W11 hybrid install media workaround.


    My SYSTEM THREE is a Dell Latitude 5410, i7-10610U, 32GB RAM, 512GB ssd, Windows 11 Pro.

johnlgalt

Antidisestablishmentarianistentarianist
Power User
VIP
Local time
1:12 AM
Posts
2,424
Location
3rd Rock
OS
Windows 11 21H2
It would be interesting to see how Rows stacks up against Excel - or Excel stacks up against Rows, as the case may be.


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:

 

My Computers

System One System Two

  • OS
    Windows 11 21H2
    Computer type
    PC/Desktop
    Manufacturer/Model
    HomeBrew
    CPU
    AMD Ryzen 9 3950X
    Motherboard
    MSI MEG X570 GODLIKE
    Memory
    4 * Corsair Vengeance 32 GB 3600 MHz
    Graphics Card(s)
    EVGA GeForce RTX 3080 Ti XC3 ULTRA GAMING (12G-P5-3955-KR)
    Sound Card
    Realtek® ALC1220 Codec
    Monitor(s) Displays
    Eve Spectrum ES07D02 280 Hz QHD | Eve Spectrum ES07D03 4K Gaming Monitor
    Screen Resolution
    1440p | 4k
    Hard Drives
    3x Samsung 980 Pro NVMe PCIe 4 M.2 2 TB SSD (MZ-V8P2T0B/AM)
    PSU
    PC Power & Cooling’s Silencer Series 1050 Watt, 80 Plus Platinum
    Case
    Fractal Design Define 7 XL Dark ATX Full Tower Case
    Cooling
    ZXT KRAKEN Z73 73.11 CFM Liquid CPU Cooler (3x 120 mm push top) + Air 3x 140mm case fans (pull front) + 1x 120 mm (push back) and 1 x 120 mm (pull bottom)
    Keyboard
    SteelSeries Apex Pro Wired Gaming Keyboard
    Mouse
    Logitech MX Master 3 for Business
    Internet Speed
    Logitech MX Master 3 for Business
    Browser
    Nightly (default) + Firefox (stable),Chrome, Edge/ß/Dev/Canary
    Antivirus
    Defender
  • Operating System
    Windows 10 x64 Pro build 21H1
    Computer type
    Laptop
    Manufacturer/Model
    Dell Latitude E5470
    CPU
    Intel(R) Core(TM) i5-6300U CPU @ 2.40GHz, 2501 Mhz, 2 Core(s), 4 Logical Processor(s)
    Motherboard
    Dell
    Memory
    16 GB
    Graphics card(s)
    Intel(R) HD Graphics 520
    Sound Card
    Intel(R) HD Graphics 520 + RealTek Audio
    Monitor(s) Displays
    Dell laptop display 15"
    Screen Resolution
    1920 * 1080
    Hard Drives
    Toshiba 128GB M.2 22300 drive
    INTEL Cherryvill 520 Series SSDSC2CW180A 180 GB SATA III SSD
    PSU
    Dell
    Case
    Dell
    Cooling
    Dell
    Mouse
    Logitech MX Master (shared) | Dell TouchPad
    Keyboard
    Dell
    Internet Speed
    AT&T LightSpeed Gigabit Duplex
    Browser
    Edge Chromium | Chrome | Firefox Nightly | Brave
    Antivirus
    Defender + MB4

jimbo45

Well-known member
Power User
VIP
Thread Starter
Local time
5:12 AM
Posts
1,871
Location
Hafnarfjörður IS
OS
Windows XP,7,10,11 Linux Arch Linux
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
 
Last edited:

My Computer

System One

  • OS
    Windows XP,7,10,11 Linux Arch Linux
    Computer type
    PC/Desktop
    CPU
    2 X Intel i7
Top Bottom