Get & Transform - I want the old SQL query wizard

[travisc]

I have office 365, and despise the power query... i use macros to modify existing SQL queries and update data in many spreadsheets.

Unfortunately power query uses a more advanced SQL format which is completely different than I'm use to. And i'm struggling to find how to modify an existing queries WHERE string. I just want to change the date range, and the macro recorder isn't recording the filter changes i'm making to show me how to do it.

 

[Jerry Sullivan]

You can still use Microsoft Query in Excel for Office 365.

 

[travisc]

amen brother, thank you!