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)
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 :
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.
cheers
jimbo
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)
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 :
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.
cheers
jimbo
My Computer
System One
-
- OS
- Windows XP,7,10,11 Linux Arch Linux
- Computer type
- PC/Desktop
- CPU
- 2 X Intel i7