Excel Ms Query - Multiple sheets possible ?? Combine queries ??


jimbo45

Well-known member
Pro User
VIP
Local time
1:09 AM
Posts
4,031
Location
Hafnarfjörður IS
OS
Windows XP,7,10,11 Linux Arch Linux
Hi folks

Any EXCEL gurus here !!

I've looked at combine queries but ????.


Using EXCEL (Office 2021) to get data from an SQL type DB (MariaDb in this case) it's simple to get data but I can only get one sheet at a time. (For those wanting to test loading data into EXCEL from any type SQL data base - just ensure the relevant ODBC driver is installed in Windows and then use get data in EXCEL)

data0.png

Is it possible to fill multiple sheets via Ms Query from EXCEL ??

Example : (all data is test and has no live data in it)

Base query :

data1.png


Now I've got another table that I want to download but not into sheet 1 but into sheet 2 -- 2nd query is fine but if I could do it in "one go" it would be so much better.


data2.png


cheers
jimbo
 

My Computer

System One

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