Is it possible to import multiple SQL statements into separate excel sheets?

[excelos]

Hello!

I want to 'Get Data From Database' and use several SQL queries so that each query is 'loaded' into separate sheets.

Is it possible to do that in a smart way without having to click 'Get Data' for each SQL query separately?

I am looking for something like a way to import these queries in bulk and download them into separate sheets.

Thanks!

 

[EFANYoutube]

Hi,
Does this help

Refreshing Data Connections Through VBA - Only working if macro is "stepped through" debugger

I am using XL2007 and have a macro that refreshes microsoft query connections. The issue is the refreshes only happen if you step through the macro using the debugger. When you run the macro normally, everything else functions properly, but the data is not refreshed. Any help is...

www.mrexcel.com

Do you already have the connections set up?

 

[excelos]

Unfortunately, I do not seem to have a connection. What I did was to click to Get Data and added one SQL statement. This resulted in a 'Query' but not a 'Connection'.

Can you provide please the full list of actions to achieve my goal?

 

[alansidman]

On the Data Tab, click on Queries and Connections. A new window will open to the right. It will offer Query and Connection. Click on Connection.

You can set up a query for each SQL on separate tabs. Clicking on Refresh All will update each query when new data has been added.

This should work, unless I am not completely understanding your requirement.

 

[excelos]

On the Data Tab, click on Queries and Connections. A new window will open to the right. It will offer Query and Connection. Click on Connection.

You can set up a query for each SQL on separate tabs. Clicking on Refresh All will update each query when new data has been added.

This should work, unless I am not completely understanding your requirement.

Thanks but there, it does not have an 'Add Query' button nor an 'Add Multiple Queries' button, if you know what I mean?

How can I import multiple queries under that 'Queries and Connections' in Excel with one click? Do I have to add each using 'Get Data'?

 

[alansidman]

You will have to build each query and close and load each to a different tab. Once all are built then when you wish to update, you would click on Refresh All on the Data Tab. I have already explained this in an earlier post.

To really understand Power Query and get the maximum benefit, I suggest you pick up a copy of "M is for (Data) Monkey" by Ken Puls and Miguel Escobar. It is available in the Mr Excel Store or on Amazon.